Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 05, 2023 12:19 AM
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/
Jun 05, 2023 12:12 PM
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.
Jun 06, 2023 04:00 AM
FYI: The easier & quicker way of doing this in Make is to use Make’s Array Aggregator.
Jun 06, 2023 07:02 AM
I'd love to see a solution using array aggregator.
Jun 06, 2023 07:05 AM
That's fair, I haven't tried it myself to be honest. I'll give it a go 🙂
Jun 06, 2023 07:22 AM
The array aggregator does exactly what you tried to recreate on your own. You used the text aggregator instead of using the array aggregator.
Jun 06, 2023 04:28 PM
@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!
Jun 07, 2023 10:59 AM - edited Jun 07, 2023 11:00 AM
@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:
Jun 08, 2023 12:47 AM
that's also an interesting way of doing it.
two solutions are better than one! 🙂