Just wanted to update with the solution in case anyone comes across this query in the future.
My array structure was incorrect - I was working with an aggregated array output that looked like this:

But what I needed to do was further distill the array by setting each variable and then parsing the JSON into the correct format.
In the end my Integromat modules looked like this:

and that produced an array with the final output that looks like this:

Once I had the array formatted correctly, Airtable was able to accept the multiple linked record ids.
Just wanted to update with the solution in case anyone comes across this query in the future.
My array structure was incorrect - I was working with an aggregated array output that looked like this:

But what I needed to do was further distill the array by setting each variable and then parsing the JSON into the correct format.
In the end my Integromat modules looked like this:

and that produced an array with the final output that looks like this:

Once I had the array formatted correctly, Airtable was able to accept the multiple linked record ids.
I think I’m struggling with the same thing are you able to share more detail?
I think I’m struggling with the same thing are you able to share more detail?
Hey Rick,
Happy to help but I don’t know what I’m doing - just a lay-user trying to force it to my will. I’ve done another similar scenario since this one and the key is definitely setting each variable and then combining them in whatever format you need. If you could share what you incoming data looks like and what you’re trying to do I could see if I could offer any pointers.
Hey Rick,
Happy to help but I don’t know what I’m doing - just a lay-user trying to force it to my will. I’ve done another similar scenario since this one and the key is definitely setting each variable and then combining them in whatever format you need. If you could share what you incoming data looks like and what you’re trying to do I could see if I could offer any pointers.
I also have a problem with arrays. Dont know how to reac an item
Just wanted to update with the solution in case anyone comes across this query in the future.
My array structure was incorrect - I was working with an aggregated array output that looked like this:

But what I needed to do was further distill the array by setting each variable and then parsing the JSON into the correct format.
In the end my Integromat modules looked like this:

and that produced an array with the final output that looks like this:

Once I had the array formatted correctly, Airtable was able to accept the multiple linked record ids.
Would you mind posting some screenshots of the syntax of the ‘Tools’ modules? I haven’t used JSON before…
Here’s another way to manage one to many relationships in Airtable that are linked by Integromat.
The problem is that a straightforward child-to-parent update will overwrite the entire parent table linking field.
So you need to copy the parent table’s linking field array and add the new child table ID, creating a new array that you will reinsert in the one-to-many fields. So you’re not appending, but rather reinserting all links with each update.
Imagine you have a parent table with the field called “child_ids”, that links to many child records. Then you have a child table with the ID “child_id”.
When you update in integromat, you’re going to blend the parent and child table using the add function.
When updagin the one-to-many field, select “map” and type in this function: “add(child_ids; child_id)”.
Put generically “add(parent_table_field_with_many_child_ids; record_id_of_child)”. Remember, parent field is an array in integromat.
Friends, I just spent hours trying to solve this same problem (how to use Integromat to link multiple Airtable records to another Airtable record), and it turns out, there’s a way easier way to solve this that doesn’t involve JSON at all (that’s what I spent all my damn time trying to recreate).
Here’s my scenario:

As @ssmith alluded to in their original post, you need to use the Tools module to change the output of the Array Aggregator module to work with Airtable. Only problem, as many people above pointed out, @ssmith never shared what they were doing with the Tools module! (or JSON, but FWIW, just avoid that altogether since it’s not necessary for Airtable linking)
Here it is:

I figured out the map() function from this Integromat video. (Make sure to reference the “raw id” of the array item you’re trying to map).
As I understand it, we’re using map() to change the output format of the Array Aggregator from an Array of Collections to a single Array.
Array Aggregator output (before re-mapping):

Tools output (after re-mapping):

This is the format Airtable needs to see when linking multiple record ID’s.
Now we insert the re-mapped array into the Airtable link field:

I don’t understand how there haven’t been more posts about this super specific requirement with linking multiple records via Integromat. Regardless, I hope this saves you from the brain-busting struggles I just went through. :exploding_head: Good luck, friends!
Here’s another way to manage one to many relationships in Airtable that are linked by Integromat.
The problem is that a straightforward child-to-parent update will overwrite the entire parent table linking field.
So you need to copy the parent table’s linking field array and add the new child table ID, creating a new array that you will reinsert in the one-to-many fields. So you’re not appending, but rather reinserting all links with each update.
Imagine you have a parent table with the field called “child_ids”, that links to many child records. Then you have a child table with the ID “child_id”.
When you update in integromat, you’re going to blend the parent and child table using the add function.
When updagin the one-to-many field, select “map” and type in this function: “add(child_ids; child_id)”.
Put generically “add(parent_table_field_with_many_child_ids; record_id_of_child)”. Remember, parent field is an array in integromat.
Best solution, thanks

Check the answer below with the ‘add’ function. It works best is this scenario.
Friends, I just spent hours trying to solve this same problem (how to use Integromat to link multiple Airtable records to another Airtable record), and it turns out, there’s a way easier way to solve this that doesn’t involve JSON at all (that’s what I spent all my damn time trying to recreate).
Here’s my scenario:

As @ssmith alluded to in their original post, you need to use the Tools module to change the output of the Array Aggregator module to work with Airtable. Only problem, as many people above pointed out, @ssmith never shared what they were doing with the Tools module! (or JSON, but FWIW, just avoid that altogether since it’s not necessary for Airtable linking)
Here it is:

I figured out the map() function from this Integromat video. (Make sure to reference the “raw id” of the array item you’re trying to map).
As I understand it, we’re using map() to change the output format of the Array Aggregator from an Array of Collections to a single Array.
Array Aggregator output (before re-mapping):

Tools output (after re-mapping):

This is the format Airtable needs to see when linking multiple record ID’s.
Now we insert the re-mapped array into the Airtable link field:

I don’t understand how there haven’t been more posts about this super specific requirement with linking multiple records via Integromat. Regardless, I hope this saves you from the brain-busting struggles I just went through. :exploding_head: Good luck, friends!
You sir are a gentleman and a scholar.
Here’s another way to manage one to many relationships in Airtable that are linked by Integromat.
The problem is that a straightforward child-to-parent update will overwrite the entire parent table linking field.
So you need to copy the parent table’s linking field array and add the new child table ID, creating a new array that you will reinsert in the one-to-many fields. So you’re not appending, but rather reinserting all links with each update.
Imagine you have a parent table with the field called “child_ids”, that links to many child records. Then you have a child table with the ID “child_id”.
When you update in integromat, you’re going to blend the parent and child table using the add function.
When updagin the one-to-many field, select “map” and type in this function: “add(child_ids; child_id)”.
Put generically “add(parent_table_field_with_many_child_ids; record_id_of_child)”. Remember, parent field is an array in integromat.
I appreciate this answer, but this only allows you to append up to 1 additional record…
Best solution, thanks

Thanks all for this post - saved me HOURS!!
I appreciate this answer, but this only allows you to append up to 1 additional record…
Worked for me - seached for 4 records within Airtable - then attached them all to a single record in another table as a linkred record (1 to many)
Friends, I just spent hours trying to solve this same problem (how to use Integromat to link multiple Airtable records to another Airtable record), and it turns out, there’s a way easier way to solve this that doesn’t involve JSON at all (that’s what I spent all my damn time trying to recreate).
Here’s my scenario:

As @ssmith alluded to in their original post, you need to use the Tools module to change the output of the Array Aggregator module to work with Airtable. Only problem, as many people above pointed out, @ssmith never shared what they were doing with the Tools module! (or JSON, but FWIW, just avoid that altogether since it’s not necessary for Airtable linking)
Here it is:

I figured out the map() function from this Integromat video. (Make sure to reference the “raw id” of the array item you’re trying to map).
As I understand it, we’re using map() to change the output format of the Array Aggregator from an Array of Collections to a single Array.
Array Aggregator output (before re-mapping):

Tools output (after re-mapping):

This is the format Airtable needs to see when linking multiple record ID’s.
Now we insert the re-mapped array into the Airtable link field:

I don’t understand how there haven’t been more posts about this super specific requirement with linking multiple records via Integromat. Regardless, I hope this saves you from the brain-busting struggles I just went through. :exploding_head: Good luck, friends!
Awesome stuff ! Thank you very much
Friends, I just spent hours trying to solve this same problem (how to use Integromat to link multiple Airtable records to another Airtable record), and it turns out, there’s a way easier way to solve this that doesn’t involve JSON at all (that’s what I spent all my damn time trying to recreate).
Here’s my scenario:

As @ssmith alluded to in their original post, you need to use the Tools module to change the output of the Array Aggregator module to work with Airtable. Only problem, as many people above pointed out, @ssmith never shared what they were doing with the Tools module! (or JSON, but FWIW, just avoid that altogether since it’s not necessary for Airtable linking)
Here it is:

I figured out the map() function from this Integromat video. (Make sure to reference the “raw id” of the array item you’re trying to map).
As I understand it, we’re using map() to change the output format of the Array Aggregator from an Array of Collections to a single Array.
Array Aggregator output (before re-mapping):

Tools output (after re-mapping):

This is the format Airtable needs to see when linking multiple record ID’s.
Now we insert the re-mapped array into the Airtable link field:

I don’t understand how there haven’t been more posts about this super specific requirement with linking multiple records via Integromat. Regardless, I hope this saves you from the brain-busting struggles I just went through. :exploding_head: Good luck, friends!
Thank you for this. I'm sure you were not expecting thanks nearly three years later, but for this issue you may even receive more three years from now.
Adding what worked for me after reading the above (thank you all!)
Using the Tools, Set variable module I used "{{flatten(add(1.CurrentlyLinked; 1.AddingLinked))}}"