Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoCan 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
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- JohnSampath16 years agoQrew TraineeThank you so much for your help. I need to able to dynamically set the formula list user field value based on status field value. (If status ="Active" then send email to the approver and reviewer users. If status ="Rejected" then send e-mail to requestor and reviewer users. etc.) These users cannot be hardcoded but come from field values. This is why I am trying to dynamically set the input parameters for the ToUserList function. I picked a webhook to do this because it did not seems like dynamic form rules, actions, automations, etc. could do this. I am open to any solution. I just want to have one notification which I can use to send e-mails to multiple users for which the users e-mail addresses come from field values. Thanks.
(Sidenote: Sheer coincidence - I found your How to make Quickbase buttons doc online earlier this morning. Great read. Thank you for putting this together)
------------------------------
John Sampath
------------------------------- JohnSampath16 years agoQrew TraineeSolved. Case([State], "In Progress", ToUserList([Requestor],[Reviewer]), "Not Started", ToUserList([Reviewer],[Approver]), null )
Thanks to Mark S. for pointing me in the right direction!
------------------------------
John Sampath
------------------------------