Email Notification Preferences
We have about 30 "open" email notifications that are sent when items are modified. These notifications are sent to over 130 unique email addresses both inside and outside of my organization, and only ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendInteresting question.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
You may not be aware but even for external email addresses you can list the recipients by field name in square brackets. For example.
[email 1]
[email 2]
[email 3]
So you can have a table of recipients and roll them all up in a Combined text summary field. The make 150! fields to parse out the separate email addresses. Yes, A bit of a grind to do tat, but it can be one in an hour as its very repetitive to make the formula fields.
The limit for a combined text summary field is 150 records, so you are OK up to 150 names without needing to resort to a separate table.
So that reduces the issue into how to have these non-users self maintain that table. It could be done with a Pipeline which is accessing a mailbox and looking say for a key word in the subject line like
Add
Remove.
and the Pipeline would either add a record or delete a record.
So I do think that it is possible but you might need some help setting up your first pipeline. But its a really good use case which is safe to test on and learn Pipelines.
[email 1]
[email 2]
[email 3]
So you can have a table of recipients and roll them all up in a Combined text summary field. The make 150! fields to parse out the separate email addresses. Yes, A bit of a grind to do tat, but it can be one in an hour as its very repetitive to make the formula fields.
The limit for a combined text summary field is 150 records, so you are OK up to 150 names without needing to resort to a separate table.
So that reduces the issue into how to have these non-users self maintain that table. It could be done with a Pipeline which is accessing a mailbox and looking say for a key word in the subject line like
Add
Remove.
and the Pipeline would either add a record or delete a record.
So I do think that it is possible but you might need some help setting up your first pipeline. But its a really good use case which is safe to test on and learn Pipelines.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Thank you for your reply! I didn't know about the combined text field - that helps me with another unrelated problem I'm having, too! Very exciting!
But I don't think I understand your suggested setup of the notifications. Are these my steps?
------------------------------
Anna Tamaoka
------------------------------
But I don't think I understand your suggested setup of the notifications. Are these my steps?
- Create an application/table (let's call it "Notifications"/"Recipients") that is open to Everyone on the internet. Fields are "Name", "Recipient Email", "Company", etc.
- Allow the Viewer role to add, remove, and edit items.
- Relate the Recipients table to the table where the notifications are (Properties) so one Property can have multiple Recipients.
- Assign all Recipients to all Properties.
- Create a Combined Text Field that combines the email addresses for each Property - one for each notification. (Combined Text Field Notification 1, Combined Text Field Notification 2, Combined Text Field Notification 3...)
- Set up the recipients in the existing Open notifications to go to [[Combined Text Field Notification No.]] instead of individual emails.
- Add something to the bottom of each email that says "to manage your preferences, reply to this email with Add or Remove".
- Set up a pipeline that reads that verbiage and manages the related Recipients table.
------------------------------
Anna Tamaoka
------------------------------
- MarkShnier__YouOne issue is that the email notification will not be able to process a single field with multiple email addresses. It will only work for separate fields. I like to list the fields vertically for readability. Hence 150 ! formula fields to parse out the 1st, 2nd 3rd.. 150th,... email address from that combined text summary field.
You have think through rough if you want an EOTI App. (Everyone On The Internet). If the pipeline is doing the work then the app does not need to be EOTI. If you actually expose the app to EOTI directly then you need to think through how you prevent someone, say a disgruntled X-employee, from messing with you data.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------