I’ve made an Airtable script to get some info automatically calling an API after populating a single field. Everything is cool besides the fact that one of the fields it’s a linked field to another table.
In this case, I would first have to create a new record in the other table and then link it (via the record id) to the table in the first “main” table.
I’d like to understand if there’s a way to get back the ID of a newly created record to link the record in the main one. I could read the values in the whole table after creation, filter them and get the ID of the created field. Tho it seems very inefficient since I’d have to read the whole thing just for a single value.
I’ve read through the docs but I couldn’t find anything about this use case. Is there a more elegant way that I’m missing?