Automation confusion

[MarineSorato]

Hello community,

I have a table called attendance where each record is the date of the event, the participant, the payment.

I want to automate the fact that each time a record is created from this table, it updates the list of participant from the table Event.

Thanks for your help,
Marine

[Pascal_Gallais- · Accepted solution]

Hello Marine,

If "attendance" table is linked to "Events" table, a rollup field should do the job:

Regards,

Pascal

[MarineSorato]

Amazing thank you !

[Sachin_191]

Hey Marine!

Let's automate that attendance tracking seamlessly with Airtable.

• We can set up an Airtable Automation that triggers whenever a new record is created in your "Attendance" table.
• The automation will then update the corresponding "Event" record by adding the participant to the list, ensuring your Event table always has the latest participant info.