Page 1 of 1

Worksheet Function to retrieve usergroups of certain user

Posted: Tue Apr 20, 2010 9:56 am
by appleglaze28
I'm currently doing a excel sheet, where admin through TM1 web can reassign users either by adding the user a new group or transferring a user from an old group to a new group?

I was thinking of creating a drop down list to enable admin to choose a specific user's current groups if he wish to remove that user from those current group he belongs to, to a new user group.

Thanks in advance for the help.

Re: Worksheet Function to retrieve usergroups of certain use

Posted: Tue Apr 20, 2010 10:41 am
by lotsaram
appleglaze28 wrote:I'm currently doing a excel sheet, where admin through TM1 web can reassign users either by adding the user a new group or transferring a user from an old group to a new group?

I was thinking of creating a drop down list to enable admin to choose a specific user's current groups if he wish to remove that user from those current group he belongs to, to a new user group.

Thanks in advance for the help.
A zero suppressed active form of }ClientGroups with groups on rows and the client selected as the title element would do the trick for current group assignments (and to remove user from group just enter spacebar in the value field ...)