Sending data from two columns to one in Airtable using Make

How To
, , ,
1

Hello Everyone,
We have been trying to send data from two different columns to one column in Airtable and we are receiving a “The operation failed with an error. [422] Insufficient permissions to create new select option” error.

The Scenario
Every time a form is submitted, a new record gets created in Sheet 1 of Airtable. This sheet has 20 columns.
Now every time a new record gets created in Sheet 1, we want to send data from six specific columns to four columns in Sheet 2 which is linked to a Projects dashboard. These columns in both sheets are ‘multi select’.

When using Airtable’s own automation this works without a hitch. But when we try this with Make, the above error is showing up.

Not sure what I am doing wrong.

2

I figured it out. We need to use the merge function to send two columns data to one.
In Airtable it was just selecting the columns. Here its a bit different.

Thank You

1 Like