When a record is updated - send an email

[Les_Gros_Becs]

Hi all!

I'm out of ideas and I need help. I have an automation which sends an email to a specific staff member (it fetches the email of that staff member in my table) when a date field is updated in a record. 

When I create a record and update the date field before adding the informations of the staff member, the automation ends up with an error message (which is normal since the email field hasn't been filled yet). 

Any ideas of how I could do the following by using an automation ? :

• When a date field is updated
• And the email field is not empty
  • Send an email

Best! 

David

[Sara]

Hi, let me know if I understood correctly.

when you create a new record, the automation start but you didn't fill out the column "staff" with the information for the email.

If it is correct, you need something to delay the automation like this:

if it isn't enough, you can add something like a formula and set as condition "when it is not empty"

Let me know if I wrong everything ahah or if you have any questions 🙂

[Alexey_Gusev · Accepted solution]

Hi,
You have a lot of options here. 
You can add conditional action 'when email is not empty'.
But I think, the better solution is to create a filtered view, when {email field} contains '@' and {email field} contains '.' (or even .com or whatever) and use in trigger setup. Still 'When record updated'  but you can choose view there.

I would also advice to lock the view and write smth like 'Don't touch, (used in automation)' in Lock explanation.
Only records present in a view, will be checked for Updating the Date field. 

[Les_Gros_Becs]

Thanks for the tip! 

I am working way too much on Airtable that I'm forgetting basic things 😛