Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: When a record is updated - send an email

Solved
Jump to Solution
1394 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Les_Gros_Becs
6 - Interface Innovator
6 - Interface Innovator

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

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

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. 

See Solution in Thread

3 Replies 3
Sara
8 - Airtable Astronomer
8 - Airtable Astronomer

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:

 

Sara_0-1701118214036.pngSara_1-1701118237470.png

Sara_2-1701118280429.png

 

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
12 - Earth
12 - Earth

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
6 - Interface Innovator
6 - Interface Innovator

Thanks for the tip! 

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