Forum Discussion
MichaelTamoush
5 years agoQrew Captain
Justin,
I've used the open notification before, the problem is the following: If I have 200 employees, and they are not users but simply need an email, using the open setting I would need to create 200 separate emails for reminders/notifications. If they are in a user field, I can just create one email.
------------------------------
Mike Tamoush
------------------------------
I've used the open notification before, the problem is the following: If I have 200 employees, and they are not users but simply need an email, using the open setting I would need to create 200 separate emails for reminders/notifications. If they are in a user field, I can just create one email.
------------------------------
Mike Tamoush
------------------------------
JustinTorrence
5 years agoQrew Cadet
Here's a hacky solution:
- Create a table of Recipients, with one email field
- Create a table called Emails with a Subject (Text), Body (Text), and Recipient (Email) field
- Create an open notification on the emails table that is sent to the email in the Recipient field when a new record is created
- Create a new pipeline that takes the following steps:
- At XX:XX time, Query the Recipients table for a list of emails
- For each Recipient:
- Create a new record in the Emails table, setting the Recipient, Body and Subject
------------------------------
Justin Torrence
Quickbase Expert, Jaybird Technologies
jtorrence@jaybirdtechnologies.com
https://www.jaybirdtechnologies.com/#community-post
------------------------------