This almost works, but it looks like the UserRoles function can only get the current users roles. I would need to be able to point at a user field and say, what user roles is that user in? That way I could say something like, If User is Not active, and userroles<>"", then send me a message letting me know to remove from user roles.
Hi Brian, I'm having the same issue and would love to have the UserRoles function for a particular user, not just the current user.
How easy would it be to add an optional second parameter to the function so that it still works for existing formulas, but also works for other users.
Still have this:
| UserRoles ("ID/Role/Empty") |
But also have this:
| UserRoles ("ID/Role/Empty", user x) |
| Description: Returns information about the user x's role. Use in a Formula-Multi-select text field. Usage examples, based on user x's role, include showing or hiding form elements, validating data, sending a webhook or email notification, or dynamic instructional text. Example: UserRoles("ID", [record owner]) returns the role ID. of the record owner. UserRoles("Name", [last modified by]) returns the role name of the user who last modified the record . UserRoles("", [record owner]), or empty, returns the role ID and name in the format ID/name of the record owner. |
