Sending Email Notification using an email formula field

OK, so what you will do is to make say 10 formual email fields called [email 1]  [email 2] etc like this



var text EmailList = ToText([My Multi select email field]);

Trim(Part($EmailList, 1,";"))




The next one would be



var text EmailList = ToText([My Multi select email field]);

Trim(Part($EmailList, 2,";"))




Then make an open notification and list those 10 fields vertically for the recipients.

Thanks that is the direction I started but I used the right function, I will try using the trim

Hi Shontay,

Are you able to set the formula email fields in the 'Notify Whom'.

I'm getting an error:
'[Requestor_Email1]' is not a recognized Quick Base user. '[Requestor_Email2]' is not a recognized Quick Base user.

Hope you can shed some light.

Thanks.

Hi, I have a field [Email Address]. Even if I have an Open Type notification, and I type in the Email Address field in square brackets, it gives an error "[Email Address] not a recognized Quick Base user"

So are we able to use a quickbase field in the Open type notification, or do we have to manually type in actual email addresses?

Try contacting support to enable the app to send to non users.