About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

How to split tags from Typeform into Airtable multiple select field

  • 31 August 2023
  • 14 replies
  • 153 views
imhavingissues

Hi!

I’m trying to put Typeform submissions into Airtable, where I want some multiple choice questions (for expample: choose 3 out of 10 options) in the Typeform to convert into tags in their respective Multiple Select column in Airtable. But anytime I submit a Typeform, those fields are filled with a single tag which contains the comma-separated string I get from Typeform. 

I tried splitting those strings with Formatter, and sending split tags in their respective Airtable fields, but then, it would only send the first one to Airtable and ignore the rest. I also tried every combination of commas and semicolons. Formatter > Utilities > Text to Line Items step also didn’t work.

How can I change that? 

 

14 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @imhavingissues 

Good question.

To help us have more context, please post screenshots of your field being used in Airtable, and examples of the DATA OUT from the Typeform trigger step.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
imhavingissues

Hi!

 

Attached you’ll find screenshots of data from Typeform, tags used in the Airtable, and the tag getting created in the current setup.

3 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@imhavingissues 

Can you post screenshots with how your Zap steps are configured?

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
imhavingissues

Attached are screenshot of my setup and the result using the Formatter. Between my Typeform trigger and Airtable record creation I have placed multiple Fromatters for all the fields that are ‘tag’ questions.

Edit: Also added a screenshot of the Airtable test result for that field.

5 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@imhavingissues 

The attachments didn’t upload.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
imhavingissues

There you go

5 Attachments
Troy Tessalone
Userlevel 7
Badge +14

@imhavingissues 

I want to add multiple different values to my "Multiple Select" Airtable field but they're all merged

If you're trying to add multiple options to fields like this:

Separate the values with commas when mapping them in the Zap editor, either like this:

Or by placing commas between fields you insert from a previous Trigger or Action, like this:

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
imhavingissues

I tried that and it still produces the same exact result. And I don’t think that’s where the issue is, as the data from Typeform already comes with commas, so it should work automatically.

Troy Tessalone
Userlevel 7
Badge +14

@imhavingissues 

You can try testing by copy/paste the field value from the Typefrom DATA OUT in the Zap trigger, and manually setting a static value in the Airtable field of the Zap action step, then test again to see the results.

 

Wondering if the issue is related to the encoding of the data, causing the commas to not be respected by Airtable.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
imhavingissues

I tried that. Setting the static value works as intended, tags are nice and separated, so you’re right - it’s most probably something with encoding of the data. I’m just lost as to what it might be...

imhavingissues

There is something that I noticed just now. After converting Multiple select field to long text, the merged tag converted to a string with quotation marks, see attached screenshot. Maybe that’s why Airtable is ignoring the commas? 

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

@imhavingissues 

If there are double quotes around a text string, then Airtable treats those as 1 selection option in single/multi select fields.

Try adding a Formatter > Text > Replace action step to remove the double quotes.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
T

Select the field that includes all of the results.  Format the data.  Type Find and Replace and do the following:

Find
,[:space:][:newline:]
Replace
,

This has to be such a pain for everyone.  This is a very common need for people who do integrations between Typeform and Airtable.  Not sure why a new line is being added to this.

R

jeez what a disappointment from Typeform. Anyway for the folks using Zapier to store a multiple choice (without “Other”) from Typeform into an Airtable multiple select field you can use this Python code block in your zap:

 

def format_input(input_string):
    items = [item.strip() for item in input_string.split(',')]
    formatted_str = ",".join(items)
    return {"output": f"{formatted_str}"}



input_str = input_data["4a"]
output_dict = format_input(input_str)
return output_dict

 

https://www.typeform.com/help/a/airtable-integration-question-mappings-and-fa-qs-14873828884244/

 

 

Reply


Terms & Conditions