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?
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.