I have a need to get the internet mail address for all users in 3 different groups. I was thinking an easy way would be to create a view that checks to see if the user is a member of the group. Is this possible? Here is the selection that I have been playing with, but it does not seem to work:
SELECT Type = “Person” & @IsMember(@Subset(FullName; 1); @Implode(@DbLookup(“Notes” : “NoCache”; “85256456:00515AD4”; “Groups”; “1CEOAll”; “Members”); @NewLine))
Any help would be appreciated!
Subject: dblookup won’t work
dblookup does not work in selection formulas.
Subject: FYI - I was able to use IntelliPrint Analytics
I have IntelliPrint Analytics installed and was able to take the view and then put some filters on it. Then, I exported the results to Excel
Subject: not in a single lookup
I don’t think it’s possible. You need to do it in two steps. Firstly, lookup the groups and get all the names in it (and watch out because there can be nested groups within groups), and then look up each one. I would do it in LotusScript, not in Formula.