send email (notification) when [Entered date / time] equals to [today's' date /time]

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
I'm trying to set up an automated email (notification) will be sent automatically when the chosen date/time equals to today's date/time. 

I've created a field (date / time) for users to add the day/time they want this notification to be sent- also I've added another Date/time formula field (Now()) - and set up rules that when [date/time] equals to Date/time formula field (Now())  to send notification - but it is not working - any suggestions? 
Photo of Eias666

Eias666

  • 60 Points

Posted 2 years ago

  • 0
  • 1
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
Notifications run off of edits made to the record.  This makes it very difficult to run a notification off of a formula field.  

That being said there is a workaround to this problem.  Set a form rule to auto fill with the user who entered the date.  Then create a report that shows the records where [Entered Date Time] = [Todays Date/Time] and fill it with information you need.  Finally create a subscription that sends this report to that user every day.  This way whoever entered that date will see the records they need to see.   Hope this helps!
(Edited)
Photo of Eias666

Eias666

  • 60 Points
Hi Jacob, thx for your comment.

But I want this email to be sent to a specific email address (of the user's choice, I've created a field where users can enter the email they want this email to be sent to), your way seems OK in case I want this email to be sent to the user itself. 
Photo of Jacob

Jacob

  • 738 Points 500 badge 2x thumb
Correct this will send a notification to the user and for subscriptions there is less flexibility with who to send it to.  If you wish to get more complex there are 3rd party solutions like Juiced Technologies' Courier.  

http://www.juicedtech.com/add-ons/quickbase-courier
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Subscriptions do not fire at soecific times. They run once a day in the morning. So it will not work to expect a subscription to run at a specific time and date.

QuickBase can do a daily morning subscription of records which meet some criteria.
Photo of Eias666

Eias666

  • 60 Points
Hi and thx for your assistance. so I understand that notification type can't be sent later on and the only way to do this is to use Subscriptions? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Yes, correct. Notifications will fire at the moment a record is edited and saved, if the conditions are met. They do not fire due to the passage of time.

SUbscriptions, however can be set up to fire say each day or each weekday. They basically run a report and if the report catches any records,, then the report is delivered. They run early in the morning, North American time zone.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Instead of making user to enter a date and time, is there a way to send a notification 7 days before the projected finish where record has not changed? 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
You can make a report with any filters you like. Then set up a subscription to send it out daily.

I'm not understanding though what you mean by where a record has not changed.
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,132 Points 3k badge 2x thumb
Thanks. That works great. I meant sending alert without a record being changed.