I have a scenario where i lookup a list of values for an item in a google sheet and want to add them as complementary values in one multiselect field for the item in airtable. in the shown example these are 12 category values coming from gsheet, which should all be added in a multiselect field for the user in airtable.
The lookup in google sheets and the JSON creation and parsing work as expected - I get a JSON with the categories like the one in the screenshot below:
The update in airtable works as well - as long as I have the JSON list elements mapped individually as single entries for the multiselect field, like indicated here:
The problem with this approach is, that if my Gsheet Lookup and resulting JSON send less list elements to airtable than I have specified in the integromat flow, the extra fields will be sent as “null” and this causes an error in the Scenario.
This is exactly the same problem as described in this post 10 months ago: Mapping Multi-Select Fields with Integromat
Within that post @cor proposed the solution to make sure that “Smart Links” is checked on the “Create a record” Module and to map the array (ex: Channel: ) rather than mapping the individual array elements. This would be a great solution for me as well:)
If i now map the array instead of the individual elements -
then the integromat flow works well and iterates in the flow thru all 12 elements from the JSON -
but the 12 elements are not added as complementary multiselect values in the airtable, but each of the 12 flow iterations overwrites the value in the multiselect field - so that at the end only one value (instead of the intended 12 in the example) is stored in airtable:
I tested this extensively, but am stuck now - any ideas what I am missing here?
THX FOR YOUR HELP!