Hey coding wizards. My company is using Airtable forms to manage customer orders inside of a club. When a new customer fills out a form, there is an “Email Address” field as well as a “Confirm Email Address” field. After the form is completed, an Automation sends an order confirmation email to the customer with the mailto: address being the “Email Address” field. But occasionally a customer will mistype their email address which will result in an Automation failure, requiring me to send the order confirmation manually. Since Airtable has yet to implement verification fields, I just use the backup email address and hope it’s correct.
I want a script that I can include into the automation that acts as an IF() statement. The logic being:
IF email automation results in a failure (aka the email address does not exist), then repeat the automation using “Confirm Email Address” field.
I feel like this could be a useful script for many service-driven workspaces in this community. If this is a simple integration I’d really appreciate any assistance since I don’t have coding experience. If not, if there’s anyone who can offer their services I’d be interested in learning more. Thanks!
Unfortunately, I’m not aware of any way to access the status of an Automation run from within a Script.
Here are some solutions to look into:
Thanks again for your response.
I can see here that there’s a Log that shows the status of automations. Could this be accessed using a script to show what has succeeded and what has failed?
Bummer, that’d be an excellent feature to have as Airtable continues developing the Automations feature!
I think for a temporary solution I’m going to set up a formula that checks if the email fields are the same, if not, it will flag the record. Then if I get a notification that the automation has failed, I’ll have a button placed that on click will execute a different automation that sends to the backup email address. It requires a bit of manual work, but we’re not ready to host our own SMTP server just yet!