I’ve been using Airtable to manage and automate registrations for events.
I set automation to confirm the registration. The trigger was a “When a record is created”, i.e. when someone completed the registration form.
After the event, I did not switch the automation off, and I inserted a new column into the same sheet to indicate who participated in the event (checkbox).
Problem: Registered people who could not participate at the event complained about receiving my automated message confirming his/her registration after the event a second time.
Previously, I assumed a record was when someone completed my form.
Please help me to understand what happened. If the inserted new column was a new record/trigger, why only just a part of registered people received the automated?