Automation to set multiple selection fields from a comma separated text field
Hi, I've got a tough one for you automation gurus!:
I am pulling over selections from Gravity Forms on a website and using Zapier to create a Jira ticket and dump those selections in. That is working perfectly, but GF / Zap dumps all of them in as comma separated values. As an example, here is the raw field I get from the Zap:
I need to use automation to take these, look for matches, and select the corresponding values in a multiselection custom field. For instance:
- If "years-startup" is present, add "option 1" in the multiselect field in Jira
- If "years-0-to-3-years" is present, also add "option 2" in the multiselect field
- Obviously, if the fields are not present, nothing would be added. The example above is with all fields selected so I know what the values look like when they come over.
Looking at Atlassian's documentation, I came up with an automation I thought would work using JSON to edit the field (custom field 10104 is the "RAW - How Long Have You Been In Business" field above, populated by Zapier):
This automation passes validation, and says successful on the audit, but nothing is changed in the multiselect field ("TEST HOW LONG HAVE YOU BEEN IN BUSINESS"). That multiselect field has Option 1, Option 2, etc to match the formula above. So basically, it says it runs, but nothing happens. I'm assuming this is because it needs to parse out the comma separated values first, but I don't know how to do that with JSON.
Please help!