How to send email remainders to Multiple users, when the date in a particular field is equal to today?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a pre-populated data in one table. One of the entries is the Date. Whenever the date in the entry is equal to today or before an email notification must be sent to a list of 3 users (they are users of Quickbase). My question is, I can do it using a remainder, but cannot send the email to all the 3 users. If I use the notifications, it gives 'AND' option i.e if any field changes and if due date is equal to today. But I'm looking only for the 2nd option. So I either need a way to enter multiple users (who do not vary with record) in the remainders. Or need a 'date equals to today' option without any change in field for a notification.

Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 64,292 Points 50k badge 2x thumb
I suggest a Subscription.  Make a report to fire daily of your qualifying records.  Say where [Date] is today.

Subscriptions can only go to members of a Role.  So one option is to make a Dummy Role of "People who get the daily reminder report", and have it be able to access no records.  It's just used to control the recipient list.    

The Subscription will run each night and fire typically before 8:00 am.
Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points
Thanks for the quick response. But for a subscription I need to select daily, weekly or monthly options. But the due date is inot in any intervals or daily. It is random. So is there a way I can send a subscription only when [Due Date] is equal to today instead of Daily or Weekly options?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 64,292 Points 50k badge 2x thumb
Set the subscription to fire Daily. The default behavior is that if there are no records in the report that day, no email will actually fire.
Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points
Thank you. I did not look at that, my bad. It works now. Thanks again.