Daily Reminder Email for records not created

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.

Welcome to the community, @David_DiVerniero!

You would only be able to do that sort of a thing by writing your own custom Javascript, or by using a no-code/low-code external automation platform like Integromat.

Every day on a schedule, you would need to search a table for a particular person’s name + the previous day’s date. If zero records are found, then you would send the email. If records are found, then you wouldn’t send the email.

Airtable doesn’t have this sort of conditional logic capability built into it, so you would have to create it on your own.

If you know how to write code, you can write your own JavaScripts to do this. If you don’t know code, you can set this up in Integromat, which is a no-code/low-code automation platform.

(Note that I am a professional Airtable consultant and a Registered Integromat Partner, and the Integromat link contains my personal referral code. If you have a budget for your project and you’d like to hire an expert consultant to help you with it, please feel free to contact me through my website at ScottWorld.com.)

1 Like