Forum Discussion

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

Thank 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
------------------------------

1 Reply

  • JohnSampath1's avatar
    JohnSampath1
    Qrew Trainee
    Solved.  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
    ------------------------------