Formatting Qualtrics data in Zapier to upload to Airtable

Hmm, if you've got automations to spare, the simpler option may be to just format it within Airtable? 

I did this by using a formula field to remove the extra commas with a SUBSTITUTE, and then you could use an automation and paste it back into the multiple select field, thus removing the blank

Link to base

You could also do it within Zapier with the text formatter tool I think!

@ICM 

#1. If you need to stick with Qualtrics, the best solution that I can recommend for you would be to switch to Make’s integrations and automations instead of using Zapier for your Qualtrics integrations.

Make has built-in array functions that let you remove the empty strings from an array before passing them onto Airtable. And Make also has about 1,000 other advanced features that Zapier doesn’t offer. 

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.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

#2. However, the best advice that I can give you would be to leave Qualtrics altogether and switch Fillout’s advanced forms for Airtable because it communicates directly with Airtable and can easily do everything that you requested natively — without jumping through any extra hoops.

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:

• Using Fillout to update an existing Airtable record & create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

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