Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Google Form response to Multi Select via Integromat

Solved
Jump to Solution
1739 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Nicole_Hawkesfo
4 - Data Explorer
4 - Data Explorer

I’m setting up an Integromat integration to watch for Google Form responses and create new Airtable records accordingly. I’ve got pretty much everything working with the exception of one field…

In my Google form it’s a multi-checkbox answer for the instruments people play, which (I believe) returns a comma-separated text string - or possibly it’s already treated as an array, I’m not sure.
The values from that need to go into a Multi Select field in Airtable.
The values in both the Google Form and the Airtable field are identical.

From what I’ve found, I think this is going to involve some kind of array parsing, but I just cannot figure out what I should do in Integromat - their own documentation on this is not at all clear, so I was hoping someone here would be able to help me out.

1 Solution

Accepted Solutions
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Nicole_Hawkesford1!

Right, Google Forms outputs multi-select fields as a comma-separated text string, so you’ll need to use Integromat’s split function to transform the text string into an array, like this:

image

See Solution in Thread

2 Replies 2
ScottWorld
18 - Pluto
18 - Pluto

Welcome to the community, @Nicole_Hawkesford1!

Right, Google Forms outputs multi-select fields as a comma-separated text string, so you’ll need to use Integromat’s split function to transform the text string into an array, like this:

image

Fantastic! Such a simple solution and works perfectly! Very, very much appreciated.