Re: Converting a cell with multiple comma separated values into a column
1
2181
0
Hello,
I am importing multiple values from zapier that are separated by a comma. I would like for them to be imported as an entire column as oppose to multiple values separated by a comma in a single cell.
As seen in the image
I’m not sure how or if this can be done in Zapier, but this is extremely easy to do with Integromat.
You can use Integromat’s split function in conjunction with the Iterator module to separate all the values by whatever separator you specify — in this case, a comma.
And then, you can do whatever you want with each value — for example, creating a new record in Airtable for each value.
Below is a screenshot of what the scenario might look like, and then I zoomed in on the Iterator module so you can see what I did there.
(I used “set variable” as my first module to set a variable called $test with a comma-separated list of text, but your first module would be the input of wherever you’re getting your data from.)
p.s. If you need to hire an Airtable Consultant & Integromat Partner to help you with this, feel free to contact me through my website at scottworld.com. (The Integromat links contain my Partner Referral Code.)
