Skip to main content

Hi there,


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:



  1. Have an automation that triggers whenever a new record is created in Table 1 or Table 2

    • Its action will be to create a new record in Table 4, and to link the two records together



  2. In Table 4, add lookup fields for the values that we want, e.g. Descriptif, etc

    • 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



Hi Benjamin, I think we just need to use linked records for this instead actually.


So if I were you, I would:



  1. Have an automation that triggers whenever a new record is created in Table 1 or Table 2

    • Its action will be to create a new record in Table 4, and to link the two records together



  2. In Table 4, add lookup fields for the values that we want, e.g. Descriptif, etc

    • 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.

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

Reply


Terms & Conditions