Home » Dynamics » How to concatenate multiple string field values in Resco Mobile CRM

How to concatenate multiple string field values in Resco Mobile CRM

Text Widget

This is a text widget. The Text Widget allows you to add text or HTML to your sidebar. You can use a text widget to display text, links, images, HTML, or a combination of these. Edit them in the Widget section of the Customizer.

Introduction:

Time and again we have received the requirement to concatenate two or more strings fields value & store it in a string field in Resco Mobile CRM.

In this blog, will provide a quick walkthrough of the process to achieve this.

Suppose we need to store the Address1 street1, Address1 street2, Address1 street3, Address1 city, State/ Province, Postal code of the Work Order record into a custom field (For Example, ‘Full Address’).

Also, we would need to reflect the changes applied to the above fields (fields that are concatenated) to the ‘Full Address’ field.

Note: As the Work Order Entity doesn’t have Full Address field. We have created a custom field ‘Full Address’.

Steps to concatenate multiple string field values in Resco:

Step 1: In the Resco Woodford project, go to the Work Order entity > Expand it > Click on the Form. Once you click on the Form, the list form will open as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM

Step 2: Now select and open the Form and add the custom ‘Full Address’ field on the form as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM1

Step 3: After adding the ‘Full Address’ field on the form, we need to write a Workflow on change of the address details (msdyn_address1, msdyn_address2, msdyn_address3, etc.) as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM

Here, we have highlighted two items that are important parts of concatenating the multiple field’s values in a single string field.

Item# 1: Variable

We added a variable ‘FullAdd’ of type StringList. (StringList type behaves like an array of string in Resco)

Once we have completed with the Variable declaration, the next step is to add the items in this variable as shown in the above screenshot.

In our case, we have added ‘msdyn_address1, msdyn_address2, msdyn_address3’ etc.

After adding all the required fields in the ‘FullAdd’ stringList, the final step is Assigning the value of variables to the field.

Item# 2: Assigning the value of variables to the field.

To assign the value of the variable to the field, we have to select the Entity field, and then click on the button next to the Entity field & select ‘Format’ option.

Now pass the Format string in the ‘format string’ text box as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM

How to concatenate multiple string field values in Resco Mobile CRM4

How to concatenate multiple string field values in Resco Mobile CRM5

Finally, click on ‘Chose Variable’ and select the variable. In our case, the variable is ‘FullAdd’ as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM6

Note: The format string {0} {1} {2} {3} {4} {5} specify the index of the items added in the ‘FullAdd’ stringList Type variable.

Save and close the Rule and Publish the mobile project.

Now, log into the Resco Mobile App and sync.

Go to the Work Order form. Here you can see the result as the ‘Full Address’ have the value as per the above requirement.

Also, when the user makes any changes in the address fields, the same changes are reflected on the ‘Full Address’ field as shown in the below screenshot;

How to concatenate multiple string field values in Resco Mobile CRM7

Conclusion:

By following the steps mentioned above, the user can easily concatenate multiple string field values in a single variable and can set it to any string field in the Resco Woodford mobile Project.

Easily Export and Email Dynamics 365 Reports in PDF, Word, or Excel

 

from Microsoft Dynamics 365(CRM) Tips and Tricks http://bit.ly/2A3DEHX
via IFTTT


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: