Question

Help with Multi-Select Options into Airtable

  • 15 February 2024
  • 5 replies
  • 90 views

Userlevel 1

Hi all -

I am working to update an Airtable table using responses to a Qualtrics survey. I have many multiple choice questions, some up to 17 options, and the column these feed to in Airtable is itself a multiselect field column (so I want each item to show up separately). At first, I had the issue that when I listed all multiple choice fields from qualtrics one next to the other, it put it in as one giant option, as shown in the right of the attached Airtable screenshot (early stage growth stage as one item). I resolved this partially by putting commas between the fields, as shown in the zapier screenshot. That turned into the left example in airtable - now they are separate items, but if an item is not selected, it still includes a blank entry. Is there a trick to resolve this? Open to all ideas - thank you!

 


5 replies

Userlevel 7
Badge +14

Hi @ICM 

Try these 2 steps

  • Action: Formatter > Utilities > Text to Line Items
  • Action: Formatter > Utilities > Line Items to Text

 

 

 

 

Userlevel 1

Do I have to do that separately for every single question? there are a lot...

Userlevel 7
Badge +14

@ICM 

See if there is a data point returned from the Zap trigger step that includes all the selected options for the question.

 

Userlevel 1

@Troy Tessalone - apologies for coming back so late on this, but I am still grappling with this - the trigger step only separates each multi-select option into an individual data point, there is no data point of all options together.

 

Any other options? Thank you!

Userlevel 7
Badge +14

@ICM 

You may have to explore an advanced approach using RAW JSON data and Code to dynamically parse and prep the data points.

Code: https://zapier.com/apps/code/help

 

Reply