Google Forms checkbox (multi-select) not mapping to Airtable in Make

Questions
1

:bullseye: What is your goal?

I am trying to capture responses from a Google Form (including a checkbox/multi-select question) and store them in Airtable using Make.

For normal fields (text, dropdown), the values are mapping correctly to Airtable.

For the checkbox question (multiple selections), I want to store all selected options as a comma-separated string in a single Airtable field.

:thinking: What is the problem & what have you tried?

The checkbox question in Google Forms returns multiple values in Make under:
answers → textAnswers → answers → value

However, when I map this field to Airtable, it shows as blank.

I tried using:
join(answers.value; ", ")

but it still does not populate in Airtable.

I also tried using an Array Aggregator, but that caused issues with mapping other fields to Airtable, so I removed it.

My Airtable field type is currently set to Long text.

:clipboard: Error messages or input/output bundles

RuntimeError
[422] Insufficient permissions to create new select option ““Every time””

Origin
Airtable
Automatic error handler
If you want to handle this error automatically, choose one of the following options. This will create a new error-handler route in your scenario. You can then expand the route in any way you like.

The first column in the Airtable is where the values captured from Google forms should appear, but it is not. the rest of the values are displayed with no errors

:camera_with_flash: Screenshots (scenario flow, module settings, errors)

Screenshot 2026-04-01 at 12.40.59 PM.png
Screenshot 2026-04-01 at 12.40.59 PM.png1188×334 17.4 KB

3

Hey there,

That error you are showing means you are trying to populate a drop-down field with an option that doesn’t exist. But that doesn’t sound like the issue toy are describing?

Can you check if the formula it self is working by putting it in a set variable module and see what it produces?

4

Your checkbox array is probably fine the real blocker is the Airtable field type/permissions. The error shows Make is trying to create a new select option (Every time) but your Airtable connection does not have permission to do that. If you want comma-separated text, map the joined value into a Long text field only, for example with join(...; ", "). If the target field is a select field, pre-create all allowed options in Airtable or enable option creation permissions.

5

thanks mate, I tried all that, but ended up changing the question format, now it works fine

6

Could have been something with the double quotes, or that you didn’t add the same exact values that were available in Airtable. And now that you changed the question, they all match, so no error.

8

thanks mate, I tried all that, but ended up changing the question format, now it works fine

9

that is exactly what happened, but hopefully get to fix or be able to add checkbox or multiselect properly with no issues in the future