Notifications: "email addresses listed in the field" not sending

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Hi,

I have an Open notification scheduled to go out when a record changes, but the notifications don't seem to send when using the "email addresses listed in the field" option in the "notify whom" field. They DO send when I type the email address manually using the "specific list of email addresses" option though.

The email field I'm trying to use is an email formula field that converts usernames to their email addresses using UserListToEmails() formula. The field is inherited from a different table via a relationship. 

When I create a test table with the email field in it, all the email addresses display appear correctly so I'm not sure what I'm missing.




 notification 
Photo of Bob Jordan

Bob Jordan

  • 274 Points 250 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Bob Jordan

Bob Jordan

  • 274 Points 250 badge 2x thumb
For anyone having this issue, the solution posted here works: https://community.quickbase.com/quickbase/topics/sending-email-notification-using-an-email-formula-f...

Basically, it seems that even though Open Notifications allows you to pick the "email list" field, the email notification system that quickbase has doesn't respect the semicolon delimited list that the field generates.

I think this is a bug/oversight within the notification system, but the workaround is to create individual email formula fields and list them within the "specific list of email addresses" field on Open notification page.