I am trying to setup a zap between ticket tailor and pipedrive that will update a multiple option field on a persons record in our CRM when they have purchased a ticket to our annual conference.
The multiple option field has values defined for each year, so the field is used to record which years people have attended our conference in the past, example below.
When trying to add information to this field from zapier, we are only able to add one option, and when running the zap it overwrites any values already in the field. Given this is a multiple option field, is there a way for the information not to be overwritten and a value be added to the existing?
Page 1 / 1
Hi @Worthstone, welcome to the Community!
The good news is that, from what I can tell, this is possible. It is going to be fiddly though, sorry about that.
The way to add multiple options to a multi-select field in Pipedrive actions is to use the option ID, with commas between each option. Looking at your screenshot, if you wanted to add 2017, 2019 and 2020 to the IIAA attendee field, you would need to select ‘Custom’ and add 87,16,15 to the field.
This means you need a step that converts the year into the relevant ID option. To do that, I recommend using Formatter by Zapier to create a Lookup table. You can learn more about how to do that in this guide: Create Lookup tables in Zaps.
The tricky part is that the Lookup table can only work with one item at a time unless you are working with line items. What you would need to do is convert your list of years into line items, run the lookup step and then convert them from line-item to text. That will give you a comma-separated list of IDs that you can put in the IIA attendee field.
That’s a lot of information, so let me lay it out in Zap steps for you:
Ticket tailor Trigger
Formatter by Zapier > Utilities > Convert text to line item - Add the years from the trigger, which will need to be separated by commas
Formatter by Zapier > Utilities > Lookup table - Add the years on the left side of the table and the option ID for the year on the right side of the table. The output of this step will be line items of the relevant IDs
Formatter by Zapier > Utilities > Convert line-item to text - Use the output of the lookup table step as the input for this step and it will output a comma-separated list of choice IDs
Pipedrive - Use the output of the last formatter step as a custom value in the IIA attendee field
If you want to give this a go, test the Pipedrive step by typing in a test custom value in the IIA attendee field to check it works. ie type 87, 16, 15, test the step, then check to see if the correct information has been passed to Pipedrive.
If you need some more information about the line item steps, check out the following help guides:
I hope that’s all clear, let us know if you have any questions!
Thank you!
After playing around with it, the formatter step was not needed. The current values from the ‘find person’ step are comma separated IDs, so add the existing years with the ID for the year 2023 in ‘update person’ step.
