{"id":10810,"date":"2017-11-24T20:27:31","date_gmt":"2017-11-24T14:57:31","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=10810"},"modified":"2017-11-24T20:27:31","modified_gmt":"2017-11-24T14:57:31","slug":"how-to-concatenate-multiple-string-field-values-in-resco-mobile-crm","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2017\/11\/how-to-concatenate-multiple-string-field-values-in-resco-mobile-crm\/","title":{"rendered":"How to concatenate multiple string field values in Resco Mobile CRM"},"content":{"rendered":"

Introduction:<\/strong><\/h2>\n

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.<\/p>\n

In this blog, will provide a quick walkthrough of the process to achieve this.<\/p>\n

Suppose we need to store the Address1 street1<\/em>, Address1 street2<\/em>, Address1 street3<\/em>, Address1 city<\/em>, State\/ Province<\/em>, Postal code<\/em> of the Work Order<\/em> record into a custom field (For Example, \u2018Full Address\u2019<\/em>).<\/p>\n

Also, we would need to reflect the changes applied to the above fields (fields that are concatenated<\/em>) to the \u2018Full Address\u2019<\/em> field.<\/p>\n

Note: As the Work Order Entity doesn’t have Full Address field. We have created a custom field \u2018Full Address\u2019.<\/em><\/strong><\/p><\/blockquote>\n

Steps to concatenate multiple string field values in Resco:<\/strong><\/h2>\n

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

\"How<\/p>\n

Step 2:<\/strong> Now select and open the Form<\/em> and add the custom \u2018Full Address\u2019<\/em> field on the form as shown in the below screenshot;<\/p>\n

\"How<\/p>\n

Step 3:<\/strong> After adding the \u2018Full Address\u2019<\/em> field on the form, we need to write a Workflow<\/em> on change of the address details (msdyn_address1, msdyn_address2, msdyn_address3, etc.) as shown in the below screenshot;<\/p>\n

\"How<\/p>\n

Here, we have highlighted two items that are important parts of concatenating the multiple field\u2019s values in a single string field.<\/p>\n

Item# 1: Variable<\/strong><\/p>\n

We added a variable \u2018FullAdd\u2019<\/em> of type StringList<\/em>. (StringList<\/em> type behaves like an array of string in Resco)<\/p>\n

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.<\/p>\n

In our case, we have added \u2018msdyn_address1, msdyn_address2, msdyn_address3\u2019<\/em> etc.<\/p>\n

After adding all the required fields in the \u2018FullAdd\u2019<\/em> stringList, the final step is Assigning the value of variables to the field.<\/em><\/p>\n

Item# 2: Assigning the value of variables to the field.<\/strong><\/p>\n

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 \u2018Format\u2019<\/em> option.<\/p>\n

Now pass the Format string in the \u2018format string\u2019<\/em> text box as shown in the below screenshot;<\/p>\n

\"How<\/p>\n

\"How<\/p>\n

\"How<\/p>\n

Finally, click on \u2018Chose Variable\u2019<\/em> and select the variable. In our case, the variable is \u2018FullAdd\u2019<\/em> as shown in the below screenshot;<\/p>\n

\"How<\/p>\n

Note: The format string {0} {1} {2} {3} {4} {5} specify the index of the items added in the \u2018FullAdd\u2019 stringList Type variable. <\/em><\/strong><\/p><\/blockquote>\n

Save and close the Rule and Publish the mobile project.<\/p>\n

Now, log into the Resco Mobile App and sync.<\/p>\n

Go to the Work Order<\/em> form. Here you can see the result as the \u2018Full Address\u2019 have the value as per the above requirement.<\/p>\n

Also, when the user makes any changes in the address fields, the same changes are reflected on the \u2018Full Address\u2019 field as shown in the below screenshot;<\/p>\n

\"How<\/p>\n

Conclusion:<\/strong><\/h2>\n

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.<\/p>\n

\"Easily<\/a><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

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\u2026 Read More: How to concatenate multiple string field values in Resco Mobile\u2026 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":10814,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,19,48],"tags":[1447],"class_list":["post-10810","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-dynamics-crm","category-resco-mobile-crm","tag-resco-mobile-crm"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t