Need a field in "Group" form of name & address book that displays all users contained in group (including nested groups)
I created a multi-value, Computed for Display, Names field in the "Group" form of the public name & address book with the following value:
@If(@IsNewDoc;"";@Name([CN
I am aware that @ExpandNameList is not supported by Lotus and from the results can see why. ACL Groups did not expand and if you make any changes to the members of a group the new list does not update when opened up again. So it is as if we took a snapshot and are stuck with that. Since I need this field to work due to pressure from up above and have no experience with LotusScript I turn to this community since I see no alternative than to script this. I have seen similar requests and have tried to implement those solutions to no avail, it is still not working.
My requirements for this are:
1) User does not need editor access in order to get this to work.
2) When the document is opened up by the user either directly in the Name & Address book or through the details button of the address dialog, a current list is seen in the new field. Field will not need to be displayed in any view whatsoever just the form.
3) The field must display all the users contained within all the groups nested within the main group. (It would be nice if there were no duplicates however that is not an issue and duplicates are fine, just recursing all subgroups and gathering a list of all users is more important.) For example:
Main Group - Group1, User1, Group2, User2, User3
Group1 - Group3, User4, User5
Group2 - User6, User7
Group3 - User8, User9
The field should show User1,User2,User3,User4,Us
4) There should not be any limit on the levels of nesting of groups and subgroups.
5) Solution should be well commented so novice scripter can understand and learn from the script. (I believe wholeheartedly in the old addage about teaching a man to fish. I would rather learn how to do something rather than it just be given me and I not understand the solution even if it works great.)
@If(@IsNewDoc;"";@Name([CN
I am aware that @ExpandNameList is not supported by Lotus and from the results can see why. ACL Groups did not expand and if you make any changes to the members of a group the new list does not update when opened up again. So it is as if we took a snapshot and are stuck with that. Since I need this field to work due to pressure from up above and have no experience with LotusScript I turn to this community since I see no alternative than to script this. I have seen similar requests and have tried to implement those solutions to no avail, it is still not working.
My requirements for this are:
1) User does not need editor access in order to get this to work.
2) When the document is opened up by the user either directly in the Name & Address book or through the details button of the address dialog, a current list is seen in the new field. Field will not need to be displayed in any view whatsoever just the form.
3) The field must display all the users contained within all the groups nested within the main group. (It would be nice if there were no duplicates however that is not an issue and duplicates are fine, just recursing all subgroups and gathering a list of all users is more important.) For example:
Main Group - Group1, User1, Group2, User2, User3
Group1 - Group3, User4, User5
Group2 - User6, User7
Group3 - User8, User9
The field should show User1,User2,User3,User4,Us
4) There should not be any limit on the levels of nesting of groups and subgroups.
5) Solution should be well commented so novice scripter can understand and learn from the script. (I believe wholeheartedly in the old addage about teaching a man to fish. I would rather learn how to do something rather than it just be given me and I not understand the solution even if it works great.)
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Change of plans, if at all possible we need to display ACL groups as well. We can work around it but if there is a solution that does not require us to work around this issue it would be greatly appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
My apologies I have been in and out of the office the last few weeks and does not look like I will be able to test this until after the new year. Thank for you assistance and hopefully I will be able to implement this shortly. I will let you know if there are any further questions that arise from this solution.
ASKER
Sorry I have been out of the office on other issues adn have not had a chance to test out the solution presented. I have not abandoned the question, just have not been able to determine if the solution given answered my issue.
TheLearnedOne,
It's only been 11 days since the last reply (even though it was just a checking-in message).
- qwaletee
It's only been 11 days since the last reply (even though it was just a checking-in message).
- qwaletee
ASKER
Thanks for the assistance on this Qwaletee. Sorry I took so long testing this out, but with your assistance it seems to work. Thanks.
ASKER
ACL groups are a nuisance however can be worked around, we mainly need mail and multi groups to display at this time, will change the group type if an ACL only group is needed. Mainly the many requesters of this information are wanting to be able to see everyone that will receive an e-mail when that group is selected to send information to.
Also for reference we are running Lotus Domino 5.0.12 just in case version is an issue.