Mapping to Multi-Select Fields with Integromat

You don’t need any of those JSON modules. But regardless of whether you delete them or not, you’ll need to use the Text Aggregator tool before sending your data to Airtable, in order to aggregate the multiple bundles into a single array.

Here are some articles on the many different types of aggregator tools in Integromat, but you will want to use the Text Aggregstor:

Thx for your answer Scott, appreciated.

If i use the text aggregator, then I get a string as input into the multiselect field - makes sense, similar to a csv. But how should that string look like, to update the multiselect field with an integromat formula properly? I have researched and tested a myriad of different delimiter combinations, but struggle to find a solution here. Airtable doesn´t split the string coming from integromat properly into separate multiselect options as i want it.

To make it more concrete and avoid misunderstanding - GSheets contains 3 categories:

crm

hr

logistics

i want to update those 3 in a multiselect field in airtable which already has exactly these categories predefined as options.

How should the final integromat formula look like to update the airtable field properly with 3 separate multiselect entries?

THX!!

You will put a comma between the values.

Thx Scott, i already had this idea as well;)

Pasting a comma separated string manually within airtable works, but input from integromat unfortunately doesn´t work that simple (at least not for me) - airtable does always only recognize one string and doesn´t split it into multiple values as intended. Result is then one value like e.g. “crm,hr,logistics”.

I have tried all combinations of Pre- and Suffixes (–> ["…","…"]) but the comma separated string gets never split into multiple values if I input it from integromat.

It works for me. Do you have “Smart Links” enabled in Integromat?

strange, yes, thats enabled.

output of the text aggregator looks like this:

config of update for airtable looks like this:

If I deselect “mapping” function for the categories filed, then this doesn´t change anything - result in airtable looks like this

A simple test of a one-step “update record in airtable” or “create record in airtable” module in integromat reveals the same problem:

if I enter comma separated values in the integromat function, then is is not converted into multiple values in the multiselect field in airtable. If I paste the same text string manually in airtable then it works as intended.

The only way to write successfully into a multiselect field in airtable that works for me is to define the values individually in integromat…:

and this leads to the problem, that in our use case the dynamic search result of a heterogeneous number of entries from Google sheets (step 1) runs in an error if we predefine such a fix number of values for the multiselect field within the airtable update module in integromat

Very weird… let me look into this. I will ask Integromat Support. I think they’re sending the data to Airtable’s API incorrectly.

@Alexander_Stump Oh okay, my bad!

All that time above when I was talking about using the “Text Aggregator” tool, I actually meant that you should be using the “Array Aggregator” tool! :crazy_face:

Multi-Select fields (and linked record fields and attachment fields) are expecting an array (not text) and only the array aggregator will turn your values into an actual array.

Sorry about that! This is why I shouldn’t be responding to posts first thing in the morning when I wake up!

No worries, thx for your help Scott!

I did initially start with the array aggregator before writing this post. The Array was build correctly, smart Links was enabled, and the array is added via mapping to the multiselect field in airtable:

…but this runs into an error within the airtable update step:

→ Error Message: “Collection can’t be converted to text for parameter ‘Value’.”

→ After this I initially switched to test the JSON modules instead of the array aggregator, yet this resulted in the “overwrite” problem that I have started this post with…

I’m sure it’s something very easy that you’re missing. Just write Integromat support, and post back here with their answer!