I am creating a make scenario that is reading a google sheet and I am updating a table in Airtable.
One of the columns that I need to update in Airtable is a column that is linked to another table.
In my scenario I have interated through and I have an array of Ids but when I try to update the column in Airtable I get this error
This is the output of my iterator
And this is my module that is trying to update Airtable
Thank you in advance for your help.
For Allocated Franchise, I think you need to supply a simple array of text values. This appears to be an array of collections.
Try something like this instead:
map({{12. Array;id)
This should grab everything with the key of “id” and create a simple array of them.
You might also be able to use an Array Aggregator before the Airtable module. In Airtable, tick on the Map option for Allocated Franchise then map in the output of the aggregator. Be sure in the Aggregator to select the data structure from the Airtable module.
Hope that makes sense!
Fantastic! Thank you for your help that worked perfectly.
