Table e‑mail notification not sending e-mail

Question

I have an e‑mail notification that I can't get to work and I after a lot of testing and searching I am still unable to figure out why it isn't working.I have a "Projects" table.&nbsp;One of the fields is "Approvers" which is a lookup to a "Project Approvers" table.&nbsp; I had earlier tried using a user-type field, but had the same issues.&nbsp; The Project Approvers table uses a single-select user field as the key field.Other notifications DO work.&nbsp;The notification owner has access to the application and table (it has an admin role and access to everything)The e‑mail notification settings are:Permission type: Recipient&nbsp; (I also test with open pulling from the e‑mail lookup field of the Approver table, either way, doesn't work).&nbsp;Notification Name: Send Approval RequestNotify Whom: The user in the field: Related Project ApproverNotify When: a Project is modified or added AND when

Any of the following fields change: Related Project Approver

Message Type: Custom messageSubject: Request to approve project: [Project Reference]Custom Message: I inserted the Action Link Example and changed the button to [Project Approver Accept Button], which is a button on the form that logs the approval in text field.Data Form: DefaultMessage Format: HTMLWhen field is blank, insert the word "empty": YesAdvanced:Operations: Only when single mission records change&nbsp; (I also tested with "For either type of change" but it made no difference)From address: The user listed in the field "Requesting staff member".&nbsp; (I also tested with notify@quickbase.com, but it made no difference.------------------------------Paul Easton------------------------------

markshnier__you · Answer

If you look at the list of notifications, is the green checkbox enabled? Is the notification active?

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

pauleaston · Answer

Yes. Under the tables Settings/Notifications, subscriptions & reminders it is listed, has a green check in the "Active" column, the user listed under "Owner" is in the admin role with full access to the app and table. Nothing is in red.

------------------------------
Paul Easton
------------------------------

markshnier__you · Answer

It's very rare but I have seen these things fail. You could try rebuilding the notification from scratch. If that does not fix the problem then either QuickBase support will have to have a look at it or if you want I don't mind having a look at it. If you want that contact me directly by the email in my signature line.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

pauleaston · Answer

Thanks. I've tried rebuilding from scratch. I'll reach out the QB support. Will report back when I have a solution.------------------------------Paul Easton------------------------------

pauleaston · Answer

Okay, I figured out where the issue is. In the subject line, I have a field reference:[Project Reference]E.g., subject = "Request to approve project: [Project Reference]"When I remove the field reference, it works.&nbsp;The field referenced is a formula text field that concatenates several other fields. It also, and this is what I'm sure is causing the issue, contains some HTML.&nbsp; When I click preview in the rule edit form, the subject shows as:Request to approve project: &lt;div style="text-align: left"&gt;COMPANY-TestChanged 1958-06-16 to 1958-06-16 TestChanged&lt;/div&gt; The field reference works in the body of the e‑mail but not the subject line.&nbsp; But the body supports HTML, the subject line obviously does not.------------------------------Paul Easton------------------------------

Forum Discussion

Table e‑mail notification not sending e-mail

8 Replies