I’m using a dynamic PDF tool (ELEDO) which gets info from Airtable to populate a contract.
Sadly, this tool can’t loop through a list of record and extract informations I need.
In particular, I have a link field of which I need to extract each individual record to populate fields which its linked content.
I’ve look into the automation but there’s no option to split infos of my linked field.
The closest think I read was this article but the link inside is dead and I don’t want to create new tables but populate fields inside the same table.
The entire Use case is this.
I have a children table
I have a parent table
-I have a link field which contains the list of children inside a parent record
I want to split the link record into other field: child 1, child 2, child 3… which are populated with records inside the link record
Any idea ?
You are correct that Airtable’s Automations can’t loop through records. However, there are a few different options for doing record looping in Airtable:
There is a workaround that you can do in Airtable that tricks Airtable’s Automations into looping through multiple records. This trick requires 2 different automations, along with setting up an extra “utility table”. I discuss how to do it in this episode of the BuiltOnAir video podcast:
The easiest & simplest & quickest way that I know of how to do this is to simply use Make.com, which is a low-code automation & integration tool that ALWAYS loops through the records that you find in Airtable. It also communicates natively with both Airtable & Eledo: