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 Use...
Forum Discussion
try this
var user UserField = [User]; // set the user field
var userlist MyUserlist = [Userlist]; // set the Userlist field
ToUserList(
If(ToUser(Part(ToText($MyUserlist),1,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),1,";"))),
If(ToUser(Part(ToText($MyUserlist),2,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),2,";"))),
If(ToUser(Part(ToText($MyUserlist),3,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),3,";"))),
If(ToUser(Part(ToText($MyUserlist),4,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),4,";"))),
If(ToUser(Part(ToText($MyUserlist),5,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),5,";"))),
If(ToUser(Part(ToText($MyUserlist),6,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),6,";"))),
If(ToUser(Part(ToText($MyUserlist),7,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),7,";"))),
If(ToUser(Part(ToText($MyUserlist),8,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),8,";"))),
If(ToUser(Part(ToText($MyUserlist),9,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),9,";"))),
If(ToUser(Part(ToText($MyUserlist),10,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),10,";")))
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
var user UserField = [User]; // set the user field
var userlist MyUserlist = [Userlist]; // set the Userlist field
ToUserList(
If(ToUser(Part(ToText($MyUserlist),1,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),1,";"))),
If(ToUser(Part(ToText($MyUserlist),2,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),2,";"))),
If(ToUser(Part(ToText($MyUserlist),3,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),3,";"))),
If(ToUser(Part(ToText($MyUserlist),4,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),4,";"))),
If(ToUser(Part(ToText($MyUserlist),5,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),5,";"))),
If(ToUser(Part(ToText($MyUserlist),6,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),6,";"))),
If(ToUser(Part(ToText($MyUserlist),7,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),7,";"))),
If(ToUser(Part(ToText($MyUserlist),8,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),8,";"))),
If(ToUser(Part(ToText($MyUserlist),9,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),9,";"))),
If(ToUser(Part(ToText($MyUserlist),10,";")) <> $UserField, ToUser(Part(ToText($MyUserlist),10,";")))
)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Got it, so a one-by-one check and insert. I guess since the limit is 20 people in a single user-list field this should be fine to implement.
------------------------------
Rosson Long
------------------------------
------------------------------
Rosson Long
------------------------------
- Right, you can keep the pattern going until you get to 20 parts.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
