Skip to main content
Question

Dynamically populating a Formula-List-User field for e-mail distribution purposes

  • April 11, 2020
  • 0 replies
  • 54 views

Use Case: I have 3 user fields: Requestor, Reviewer, and Approver.  I also have a status field. Based on the status field value I want to send an e-mail to possibly two or three users. This needs to be one e-mail only so that all users are aware of who got the e-mail.  (i.e. copying the notification multiple items and changing the recipient will not work.) 

What I have tried:  I have set up a formula-list-user field called Distribution_List. I am utilizing the ToUserList function to populate this through a Webhook. On adding a record I am trying to edit the Distribution:List field. (Please see attached image.)

However I am getting a 404 error. I am thinking there are 2 possible issues. (my entire methodology is flawed, my Webhook syntax is incorrect.) 

Any assistance would be greatly appreciated. Thank you. 



------------------------------
John Sampath
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • April 11, 2020
Can you explain why you were trying to use the webhook?  Why can't you just have a formula list user field and send the email to that field?


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------