Hi Fusion Community,
We have field called 'Service Area' in our Salesforce Org. It is a (single select) picklist field, but is changing to a multi select picklist field. This field currently syncs data bi-directionally (SFDC --> WF and WF --> SFDC) to a related Service Area field on a program custom form in Workfront.
It's looking like I need to change my Workfront field from a dropdown field to a text field to house what's coming from Salesforce if more than one value is being passed (e.g. Strategy, Implementation, Assessment). However, making the Workfront Service Area field a text field leaves us open to data quality issues if someone updates these values in Worfkront, and inputs an incorrect value, and the system then needs to sync data back to Salesforce.
Is there anything in Fusion I can do whereby I can keep both Service Area fields in each system as multi select picklists and still pass data bi-directionally (e.g. parse incoming data into an array and map each value to the existing values predefined in each systems' field)?
Thanks!
Nick
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hello Nick,
Sorry, I think I accidentally posted the wrong expression...
This is my setup of the module:
I'll keep my fingers crossed that it works for you.
Regards
Lars
Nick
I'm not sure why you need to change the WF field to a text field? You can have a dropdown be multiselect in Workfront, or you could use a checkbox field as well.
Views
Replies
Total Likes
Hey Chris -
The data coming in from Salesforce is one bug clump of many values separated by semicolons:
When Fusion goes to map this data to the multi select dropdown field in Workfront (Service Area), it looks at the massive clump of values coming from Salesforce as one value and tries to find the related value in my Workfront Service Area field.
I need it to parse out all of the semicolon separate values and then go and find and select its sister value in my Workfront Service Area field. All the same values exist in the Service Area field in both systems.
Views
Replies
Total Likes
Hello Nick,
You could use the Match pattern module from the App Text Parser.
Using the pattern (?values.[^;"]+|("[^"]*")+) and checking Global match will provide you with each value separated by a semicolon.
In the next step you should use an Array aggregator and in your final Update Record module, you just need to map your array by value
{{map(171.array; "value")}}
Regards
Lars
Views
Replies
Total Likes
If you pass the string thru a split(;{your field};;), then it should give you an array, then you should be able to map it directly. Note, put the semicolon you want to use for the split in before anything else, or fusion will think it's part of the code and it won't work. (There shouldn't be the grey box around it)
Views
Replies
Total Likes
Thanks, Chris and Lars.
I've tried both without success so far.
Lars, this is what I got when using Text Parse Match Pattern:
This is how I set it up:
Chris, here's what I'm getting when I try your method:
This is how I set it up:
Might I have misinterpreted some of the direction?
Thanks!
Views
Replies
Total Likes
Hello Nick,
Sorry, I think I accidentally posted the wrong expression...
This is my setup of the module:
I'll keep my fingers crossed that it works for you.
Regards
Lars
Wonderful, that worked! Thanks, Lars!
Views
Replies
Total Likes
Nick, glad you got it working!
For future readers, I mistyped the formula, there was an extra semicolon in the beginning. It should have looked like this.
Thanks, Chris!
Views
Replies
Total Likes
Views
Like
Replies