Notifications from Enumlist of Email Addresses

Hello,

How do I get email addresses into the “To:” section of the notification bot when the list of emails is selected from an enumlist which has suggested values taken from another table.

I have the following set up:

A notification form which has various fields including:

  • Date (Date/TIme Field)
  • Useremail() (Auto-populates with (USEREMAIL())
  • Select Recipient (EnumList populating from an additional table (staff information)
  • Notification Title (Text Field)
  • Notification Text (Text Field)
  • Send Notification (Yes/No Field - Used to confirm if the message is to be sent via automations)

A bot set up to send notifications for adds only

Process: TO: field - id like it to be all of the Selected Recipients from the form

Hey,

here you go man:
https://support.google.com/appsheet/answer/11447614?hl=en#add-email-recipients