RossonLong1
5 years agoQrew Cadet
Filtering User List Formulas
Hi! I am trying to find a way to filter a user list.
Fields:
User (single user field)
User-List (multiple users field)
Filtered User-List (multiple users field)
Example:
User has:
U1
User-List has:
U1;U2;U3
Goal:
Filtered User-List has:
U2;U3
Problem:
I've tried stuff like
ToUserList(
Left([User-List],[User])
Right([User-List],[User])
)
But User-Lists don't have the same rules as normal text fields and therefor I can't modify them like I would a text field. I also can't figure out a way to turn them into text fields, filter them, and then back into QuickBase Users. (If that's even possible).
Any thoughts on how to filter these User-Lists in the way I presented above?
------------------------------
Rosson Long
------------------------------
Fields:
User (single user field)
User-List (multiple users field)
Filtered User-List (multiple users field)
Example:
User has:
U1
User-List has:
U1;U2;U3
Goal:
Filtered User-List has:
U2;U3
Problem:
I've tried stuff like
ToUserList(
Left([User-List],[User])
Right([User-List],[User])
)
But User-Lists don't have the same rules as normal text fields and therefor I can't modify them like I would a text field. I also can't figure out a way to turn them into text fields, filter them, and then back into QuickBase Users. (If that's even possible).
Any thoughts on how to filter these User-Lists in the way I presented above?
------------------------------
Rosson Long
------------------------------