Update User List field using actions or automations

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I am trying to update a user list field using an automation, but all I am able to do is override the whole list with a single user. Is there a way to do this? Maybe a workaround I could use?

Thanks
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
if you are trying to add an additional user to the user list, you could make a formula which calculates to the new result that you want and write it into the field.

ToUserList([My Userlist field], ToUserlist([my additional user field]))
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
I do think it needs to be a user list type. The field is primarily used in an automatic notification I have set up that emails each user in the list. 
You would need to make a formula which would detect if a semi colon delimited string of email addresses contains the email address of [Last Modified by], and if not then add it to the list.

Then you would need to have say 20 or so fields to parse out all those email addresses so you could use them in a notification.  A Notification would need to have separate fields.
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
So bypass the user list function altogether? I guess that could work. But then how do I automatically trigger that formula? I suppose it could be a button or something if need be. 
I have not thought through the whole formula, but the function User() is the current user and hence UserToEmail(User()) will be who will be the [Last Modified by] when the record is saved.
Photo of Alex Gale

Alex Gale

  • 1,462 Points 1k badge 2x thumb
Ok. I'll see what I can do with these ideas. Thanks for all your help, I really appreciate it. 
Photo of Kirk Trachy

Kirk Trachy

  • 224 Points 100 badge 2x thumb
I had a similar problem and solved it with automations.

Say you have a list-user field and it has a couple of names in it and you wish to add another name to the existing list-users.

You can use an automation and when the triggering event happens, an automation fires to edit the record (in this example the record I'm on where Record ID# is equal to Record ID#).  It edits the List-User field with the value of itself concatenated with the new email address.

See below.



You can also use an automation to set the default values of a List-User field as well.

I.e., when the record is created edit the record where the Record ID# is equal to the value of the Record ID# (itself) and

target the List Users field with "Type a value" and put the email addresses chained together with a semicolon.  Like this:


(Edited)