Splitting field CSV contents for Zapier

[jamiesw]

Hi there,
I have a form that gets data from Zapier, however one of the fields is a comma separated list. (I cannot separated it in zapier it comes from elsewhere like that)
How can i copy that fields data splitting the field using the commas and inserting the data into the respective fields?

MyCommaSeparatedField: Mr,John,Smith,1982-12-23,+44123456789,Yes,Yes,Someotherdata,

Into these fields:
Title, Firstname, Lastname, DoB, Phone, FirstAider,EmergencyContact,Whateverelse

thanks
Jamie

[chrishajer (Chris (Gravity Forms))]

Hi Jamiesw. You could use the gform_zapier_field_value filter for that:

gform_zapier_field_value - Gravity Forms Documentation

Or you should be able to use a Formatter on Zapier’s end to split up that csv into separate fields:

The Zapier Formatter Guide: How to Automatically Format Text the Way You Want