Specific time for email notification

Hello, Stacey, 



My name is Lovell and I am with QuickBase Care. Thank you for your question. Unfortunately there isn't a way to determine when a notification can be set. 



Regards, 



QuickBase Care

I have a similar issue that I would look to send a notification or alert based on weeks to go scenario. If I cannot achieve this as part of the notification, do we have any other option?

You can use a "Reminder" type email as opposed to a Notification.

I am aware of other types of alerts.  Reminder is so basic that it does not allow you attach a report.

Then send a Subscription report. Make a report that catches the record say 2 weeks ahead of some date and fire it every day.

That is the problem.  I need to send a subscription even if there is no change in the data. Could there be a data that changes by the calendar  and triggers?

You can make a formula checkbox field with a formula that will be true if today is say seven days ahead of your date field.

Then set up a subscription report with that filter. The only records that will be on that report will be records which are exactly 7 days I had off your date field.

Thanks Mark.  Tried to use the following to create a check box but this is selecting records even later than the alert date.

If(
Today() < -Days(7), true)

Make it =


If(
Today() = -Days(7), true)

As always, grateful for the guidance.