Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Nov 27, 2023 11:51 AM
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 ? :
Best!
David
Solved! Go to Solution.
Nov 28, 2023 06:07 AM - edited Nov 28, 2023 06:09 AM
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.
Nov 27, 2023 12:58 PM
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 🙂
Nov 28, 2023 06:07 AM - edited Nov 28, 2023 06:09 AM
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.
Nov 28, 2023 06:34 AM
Thanks for the tip!
I am working way too much on Airtable that I'm forgetting basic things 😛