Update User List field using actions or automations
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?
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]))
Wouldn't that only work with some set number of users? My workflow here is that whenever a record is modified in a certain way, I want the record owner of that record to be added to the user list.
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:
