RE: How 2 sort CHECKBOX Choices that use "Use formula for choices" Domenic DiSorbo 17.Sep.04 03:51 PM a Web browser Domino Designer -- Forms 5.0.7aAll Platforms
Mark,
Thank you
Thank you
Thank You
It worked!!!
A nested replace, they always give me trouble (maybe its the dyslexia) that's why I used at keywords. Lets see If I understand it.
The inner replace takes TR (all Team Roles stored in a form/view cuz I couldn't find a way to do a get @AllRoles) and for every UR (roles that the current user has) it find it changes them to spaces. - This almost looks like its giving you all the roles the user doesn't have.
The outer replace takes TR (All Team Roles) and for every "results of the inner replace" (which are roles the user doesn't have) it finds it changes them to spaces so you are left only with the roles the user really does have. The trim removes all the dead space.
Cool .. and pretty tricky I just have a difficult time wrapping my mind around it. Its like a manual @keywords
P.S. Yes I did find some script that would get all roles for the current session but I didn't know how to combine it with the @ formulas.