You have run into one of Airtable’s quirks.
When you create a record and enter data in the user interface, the record is created with empty values, so your data entry is considered an update to the record.
However, when you create a record with a form, the record is created with the values from the form, and there is no “update” to the values. Thus, the “record updated” automation is not triggered.
Having another copy of the automation to run when the new form is submitted is one possible way of dealing with the situation. Another possibility is looking for a “when record meets conditions” that fits both situations.
You have run into one of Airtable’s quirks.
When you create a record and enter data in the user interface, the record is created with empty values, so your data entry is considered an update to the record.
However, when you create a record with a form, the record is created with the values from the form, and there is no “update” to the values. Thus, the “record updated” automation is not triggered.
Having another copy of the automation to run when the new form is submitted is one possible way of dealing with the situation. Another possibility is looking for a “when record meets conditions” that fits both situations.
So there is now a way to schedule the run of Automations and that’s another way to get this https://support.airtable.com/hc/en-us/articles/1500001756941-At-a-scheduled-time-automation-trigger?