Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
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]))
ToUserList([My Userlist field], ToUserlist([my additional user field]))
- AlexGale7 years agoQrew CaptainWouldn'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.
- QuickBaseCoachD7 years agoQrew CaptainThe Limit appears to be 10 users.
https://login.quickbase.com/db/6ewwzuuj?a=dr&r=fx&rl=dy6
But it is smart enough not to duplicate users. Do you need the result to be a List User field type? Or can it be simple text? - AlexGale7 years agoQrew CaptainI 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.
- QuickBaseCoachD7 years agoQrew CaptainYou 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. - AlexGale7 years agoQrew CaptainSo 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.
- QuickBaseCoachD7 years agoQrew CaptainI 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.
- AlexGale7 years agoQrew CaptainOk. I'll see what I can do with these ideas. Thanks for all your help, I really appreciate it.