Zoho Deluge: Push Multi-Select Picklist containing Commas from CRM to Creator
- Joel Lipman
- Zoho
- Hits: 14992
A very quick article on how to push a multi-select picklist from CRM to Creator.
Why?
We're trying to create a record in Creator off a button on the CRM Potential/Deal record. The CRM module has a multi-select picklist which will use commas to delimit but one of the options has a comma in its value.
// What I have in CRM: {"My_MultiPicklist":["Option1","Options 2, 3"]} // What Creator understands: FAILS {"My_MultiPicklist":["["Option1","Options 2, 3"]"]}
- // What I have in CRM:
- {"My_MultiPicklist":["Option1","Options 2, 3"]}
- // What Creator understands: FAILS
- {"My_MultiPicklist":["["Option1","Options 2, 3"]"]}
// What Creator understands: FAILS {"My_MultiPicklist":["Option1","Options 2"," 3"]}
- // What Creator understands: FAILS
- {"My_MultiPicklist":["Option1","Options 2"," 3"]}
How?
So the way to push this value over to Creator is by converting the list to a string... notably comma delimited: