Skip to main content
Solved

Notification when there are no new records

  • November 16, 2023
  • 4 replies
  • 41 views

Forum|alt.badge.img+3

Is there any way to be notified when a base has no new records in a period of time.

I'm creating a base where managers need to leave a new record at least once every 30 days.  I want to be alerted when they have NOT left a new record since the last one was posted.

Anyone know of a way to do this?

Best answer by BillH

I think something like this should work.  I checks a table to see if anything has a creation time after one month ago (or whatever you need), if the find is zero records it sends an email notification.  Maybe not exactly what you envisioned, but the concept is possible within automations.

 

 

4 replies

Forum|alt.badge.img+3
  • Author
  • New Participant
  • November 16, 2023

I'm not seeing anything on Airtable and am trying to use Zapier.  I can't figure it out either!  Hopefully, someone here has done this automation previously!


BillH
Forum|alt.badge.img+24
  • Brainy
  • Answer
  • November 16, 2023

I think something like this should work.  I checks a table to see if anything has a creation time after one month ago (or whatever you need), if the find is zero records it sends an email notification.  Maybe not exactly what you envisioned, but the concept is possible within automations.

 

 


Forum|alt.badge.img+3
  • Author
  • New Participant
  • November 16, 2023

I think something like this should work.  I checks a table to see if anything has a creation time after one month ago (or whatever you need), if the find is zero records it sends an email notification.  Maybe not exactly what you envisioned, but the concept is possible within automations.

 

 


You are my hero!  Thank you!  I'm still learning what all automations can do and this is great.  Thanks!


BillH
Forum|alt.badge.img+24
  • Brainy
  • November 17, 2023

I'm glad it was helpful.  Good luck and don't be discouraged along the path.  I use some Automations, some Make scenarios and some Zapier, and even when they do the same thing the different interfaces can be very confusing.