The key thing to know is to never use a text field to trigger an automation. That’s because Airtable continually evaluates the field while the person is typing, so the same automation will fire multiple times in a row while the person is typing.
Checkboxes and single-select fields are the 2 best field types to trigger automations.
I really like creating “Action” fields which are single-select fields. These fields give my clients a list of automations to choose from, and then the automation will update the field with either “Done” or “Error” so they know what happened.
See screenshot below for an example of this.
Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld