Help

Linking Multiple Records in Airtable

3377 8
cancel
Showing results for 
Search instead for 
Did you mean: 
Cosmin
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi!

I recently made a video on how you can dynamically link multiple records in airtable to a single one using make. 

I know for a fact this is something quite a few people struggle with. 

Here's the video!

https://www.youtube.com/watch?v=rWed6E8Fp0o&feature=youtu.be

Here's a written guide on how to do it also:

https://flexnocode.ghost.io/how-to-link-multiple-records-in-aritable-to-one-in-aritable/

 

 

8 Replies 8

Nice job!

Btw, this can also be easily done entirely in Airtable utilizing a Find Records automation step to search for records matching a condition in one table and then an Update Records step to update the linked record field in another table.

@Cosmin 

FYI: The easier & quicker way of doing this in Make is to use Make’s Array Aggregator.

Cosmin
5 - Automation Enthusiast
5 - Automation Enthusiast

I'd love to see a solution using array aggregator.  

That's fair, I haven't tried it myself to be honest. I'll give it a go 🙂 

The array aggregator does exactly what you tried to recreate on your own. You used the text aggregator instead of using the array aggregator. 

Cosmin
5 - Automation Enthusiast
5 - Automation Enthusiast

@ScottWorld nope. That is actually not correct. The array aggregator simply doesn't give the same kind of output. 

Nevertheless, I'd love see how you are right and I am wrong on this specific matter. 

Cheers!

ScottWorld
18 - Pluto
18 - Pluto

@Cosmin Oh, I see what you're saying — I tried this and it didn't work. This actually could be a bug in Make... I will report it to them and see what they say. 

The other easy way of doing this is in Make to simply set a variable to an empty array, and then keep appending new record ID's into the array that you just created. Then you will have an array that you can place into the field.

Check out the thread below on how to do this... it is very easy. This example uses Calendly as the input, but you could easily do this with other apps as well:

https://air.tableforums.com/t/need-to-add-an-array-of-linked-record-ids-into-an-update-records-linke...

Cosmin
5 - Automation Enthusiast
5 - Automation Enthusiast

that's also an interesting way of doing it. 

two solutions are better than one! 🙂