The Automations do run without any issue when I enter the data directly in Airtable. However, I found out, they do not run if the data is submitted via Airtable Form.
I am not sure why they decided to behave this way. If the data is entered, I would expect the automations behave same way, regardless how the data was entered.
In my case my Automations have trigger to run when a field of a record is updated. That works well for both entering new data or updating existing data.
So I guess I will need to create another copy of my existing automations and set the trigger to run when a new form is submitted??
I guess I have to use the form trigger. Just find it unnecessary.