I’m still a bit of a newbie on Airtable and I’ve searched quite a bit how to solve my problem but for now I can’t find it.
I have created a database with different tables that have different functions:
1 - a table with events and their characteristics
2 - a table with spots related to these events. Which allows me to optimize the kanban view
3 - a contacts table
4 - a specific board where I would like to use the timeline function to bring out events from boards 1 & 2.
My concern: I would really like to automate table 4 to avoid double entries. So I used an automation to create records in table 4 as soon as a record is created in table 1 or 2. So far so good.
Now I would also like to automate the updating of records in table 4 when a record is modified in table 1 or 2. And therein lies the drama. I have looked at some topics, but I can’t configure the ID records in the automation. There is always an error detected during the test phase.
Could you help me? Here is a copy of the base
Thanks a lot.
Hi Benjamin, I think we just need to use linked records for this instead actually.
So if I were you, I would:
- Have an automation that triggers whenever a new record is created in
Table 1 or
- Its action will be to create a new record in
Table 4, and to link the two records together
Table 4, add lookup fields for the values that we want, e.g.
- Assuming I have a
Descriptif field in both
Table 1 and
Table 2, I would then create another formula field to compile the two fields
Thank you very much @Adam_C for your precious help. This is where I’m stuck, I still have trouble understanding how linked records works.
I have created the automation so that the record is created in table 4 when I enter in table 2 (for the example). You can test from table 2 if you want. But I can’t figure out how to make the linked record in table 4 without having to manually select the record in linked table 2.
Hi Benjamin, yeap I see what you mean. I’ve put something together for you in your base which I think should clarify things