How can I create a form email to an a non-Quickbase user email address in a record based on a calculated field?

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

How can I create a form email to an a non-Quickbase user email address in a record based on a calculated field?  

e.g. A table includes a renewal date and email field.  When renewal date > 45 days from today, generate an email to the email address in the record.  

How can I create a form email to a non QB user using this method?

Photo of Michael Carstensen

Posted 3 years ago

  • 0
  • 1
Photo of Blake Harrison - DataBlender

Blake Harrison - DataBlender, Champion

  • 100 Points 100 badge 2x thumb
The way you've outlined the requirement (send an email based on when a date comes around, rather than when an action happens) would only allow you to send a Reminder, which cannot be sent to non-users. Reminders also don't have quite the formatting options that standard Email Notifications do. Email Notifications, however, are triggered when a user makes a change to a record which meets the criteria set in the Email Notification. The criteria can be based on date formulas, but a change must occur in the record for it to trigger.
Photo of QuickBase Tools

QuickBase Tools

  • 22 Points
Blake explained this one very well.

If you are stuck and are ok with a non-native solution, we can help.  With our add-on, Courier for QuickBase, you can use a report in your app that identifies the records that meet the > 45 days from today criteria and Courier will send a separate email to each record in that report even if they are NOT users in your application.  You can copy and/or blind copy additional email addresses, you can customize the email message body and you can include file attachments.  It does not have to be triggered, it will run every day and if no records meet the report criteria then no emails are sent.  You can also log the email activity in a table in your app so you have a record of the emails that were sent out.

more here...http://www.quickbasetools.com/#!qb-courier/c1t45

Keith