Skip to main content
Question

Send an email if there are no entries for today

  • January 13, 2026
  • 3 replies
  • 21 views
dapa
Forum|alt.badge.img+1

Hi all!

I'm trying to make something in Airtable which I think should be possible, but I haven't quite wrapped my head around how to make it do what I want.

Here's the situation:

  1. I want a team to fill out a form with information which can apply to specific regions and/or date ranges.
  2. If one or both of the regions does not have an entry for today, I want to send them an automated email reminding them to submit an entry.

I've got a base structure which looks something like this:

The form part is easy, I have no worries there. Also, I was already able to set up formulas in the last 2 columns which determine if today or tomorrow is between the start and end dates.

I thought I could then use logic in Automations to send an email if it encounters entries where:

  1. “Today within range” = not ticked anywhere
  2. “Today within range” = ticked in one or more entries, but Region 1 is not ticked in any of these entries
  3. “Today within range” = ticked in one or more entries, but Region 2 is not ticked in any of these entries

As you may have seen in the way I worded the above, a complicating factor is that there can be multiple overlapping entries, as regions can be submitted independently of each other.

Does someone have an idea of how to do something like this, if it can be done with Airtable? I can't really figure out the Automations part of this puzzle.

Thanks in advance for your brainwaves! :)

3 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Hm one way to handle this is with a new table where each record represents a single region for a single day like so:

Which would allow you to link the form submissions via an automation to the appropriate day and create rollups and formulas so that you end up with this:

And your automation would then trigger at like 11pm every day and look for a record where ‘Is Today’ is true and ‘Send email alert’ is true

I’ve set it up here for you to check out

---

You could also do this without an extra table with some scripting too

Adam, Airtable Consultant - thetimesaving.company
    dapa
    Forum|alt.badge.img+1
    • dapa
    • Author
    • New Participant
    • January 13, 2026

    Entry per day would be a bit painful for the person filling out the form in this case, but the idea of splitting the regions out to their own ‘worker table’ with some kind of lookup is definitely interesting. I'll play around with that some more, thank you!

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hmm, I’d recommend tinkering with ChatGPT to create a script for you to use with an automation that’ll take the Start and End date and create an array of the dates in between

    You could then output that into a Repeating Group that’ll:

    1. Look for that Date in the Dates table
    2. Use a conditional to check if it found it, and if it didn’t create it

    Let me know if you could use some help with that and I’ll put something together!

    Adam, Airtable Consultant - thetimesaving.company
    Terms & ConditionsAccessibility statement