Update User List field using actions or automations

  • 0
  • 1
  • Question
  • Updated 5 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,124 Points 1k badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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,124 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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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,124 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. 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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,124 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.