Forum Discussion

Eias666Eias666's avatar
Eias666Eias666
Qrew Trainee
9 years ago

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

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...
JacobJacob's avatar
JacobJacob
Qrew Cadet
9 years ago
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!
  • Eias666Eias666's avatar
    Eias666Eias666
    Qrew Trainee
    9 years ago
    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. 
  • JacobJacob's avatar
    JacobJacob
    Qrew Cadet
    9 years ago
    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