Hi Kristina
For part 1, the trick is to use a Formatter Zapier step configured as follows:
Which will replace the ,space newline between values from type form to just a comma. Involved a little trial and error but seems to work.
I haven’t experimented with your second question but there is probably a similar solution - let me know if not!
Julian
Hi Kristina
For part 1, the trick is to use a Formatter Zapier step configured as follows:
Which will replace the ,space newline between values from type form to just a comma. Involved a little trial and error but seems to work.
I haven’t experimented with your second question but there is probably a similar solution - let me know if not!
Julian
Worked like a charm!! It’s 2021 :raised_hands:
Yes, this works! So helpful. Thanks.
Will this work for multiple questions? In other words, if we have multiple questions where there are multiple options allowed.
Do we need to create a new filter step for each of these?
Instead of using Zapier, this is much easier accomplished by using Make’s TypeForm integrations.
In general, I would strongly recommend against using Zapier, because Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier.
I wrote an entire post here comparing Make vs. Zapier, and if you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread.
However, your much better option than using TypeForm is to switch to Fillout’s advanced forms for Airtable because it communicates DIRECTLY with Airtable, so it feeds directly into Airtable’s single-select fields, multiple-select fields, linked record fields, attachment fields, etc.
Even better:, Fillout is 100% free, and it offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, create custom PDF files from a form submission, accept payments on forms, pre-fetch dynamic data from an Airtable record, customize the style and branding of your form, customize a theme for your form, display Airtable lookup fields on forms, create new linked records on a form, add a login page to your form, perform math or other live calculations on your forms, collect signatures on a form, create multi-page forms with conditional paths, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.
I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:
Hope this helps!
If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
