Hi! I’m trying to create an automation that will send out a reminder email if a record has not been created on the previous day:
My team members each fill out an air table form every weekday. One of the fields is a dropdown with their name. I’d like to make an automation for each team member that will send out an email to them if the previous day does not have a record with their name.
The automations don’t really seem to be set up for If/Thens based on records that HAVE NOT been created, but I’m pretty new to the whole thing. I have gone down a few rabbit holes on methods but I can’t seem to figure out what I imagine shouldn’t be a terribly complicated solution.