I have a list of email ids in .csv. How can I link them to a table in Quickbase, so that the notifications for open recipients, takes these Email ids directly?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

To put it simply, I have 3 check boxes in my table. Depending on a condition, any one of those check boxes are checked. I have set up 3 email notifications, such that when each one of them is checked, that particular email must be sent to a list of users. Currently I am manually entering all the email ids in 3 open recipient boxes. Is there a way I can associate different csv files containing these 3 different set of email ids to the table notifications, so that it takes the email ids directly?

Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
Can you provide a little bit more context here? Do the lists of e-mails change per record? You cannot insert a CSV into an e-mail notification list but can use a field.
Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points
The list of email ids are different for the 3 records. When I use a Email field, I am able to only insert or select one email id and not a group or a list of email ids. Thank you.
Photo of Harrison Hersch (MCF)

Harrison Hersch (MCF), Champion

  • 40 Points
You can insert multiple fields in the e-mail recipient list by doing each field in brackets just like a formula.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,320 Points 50k badge 2x thumb
.. or you can just copy and paste in a whole list of hard coded email addresses.
Photo of Jeff

Jeff

  • 20 Points
Hi Auro,

The suggestion Harrison has about using multiple email fields would be the best option. This way you can import different email addresses for each record and the notification will trigger out to the appropriate recipients. If you are having difficulty getting this to work, you can feel free to submit a support case and we can take a look at it with you.

Best,

Jeff
Photo of Auro Sai Vijay

Auro Sai Vijay

  • 0 Points
Thanks for the answer. I am currently using multiple Email fields. But that seems like a time taking process. Is there a way I can create a group say "Contacts_1", "Contacts_2", "Contacts_3" and put them as a drop down list in a Email field, so that if I check box 1 then I can select "Contacts_1" from the dropdown below. Similarly checking box 2 will take "Contacts_2" and so on? I am able to aomplish what I wanted even now. But I was just checking if there was a better procedure.

Thanks Again.