Monthly Notification if NO records are found

  • 1
  • 1
  • Question
  • Updated 2 months ago
  • Answered
I'd like to send out a notification if no new records have been added for a given month.  For example if we have not received a payment from a customer for a particular month how can I send a notification (when there is no trigger)?  Thank you in advance for any suggestions.
Photo of Brett Hinman

Brett Hinman

  • 130 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 53,240 Points 50k badge 2x thumb
You will need to create a summary field on a Parent table for # of records added "During the Previous month". 

Then run a subscription report on the 1st of the month on a report were the filter is that count = 0.
Photo of Brett Hinman

Brett Hinman

  • 130 Points 100 badge 2x thumb

Thank you that did the trick!