How to merge all name field items in a group

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fbartrom - 09 Mar 2006 18:30 GMT

I have a group called "TeamMembers". In that group I have a string field
called "UserName" I have a field that is not in that group called "UserList"

How do I create a rule that merges or concatenates all the "UserName" items
in the "TeamMembers" group into the "UserList" field?

The rules I have created so far only return the first "UserName" item in the
group.

Reply to this Message

S.Y.M. Wong-A-Ton - 10 Mar 2006 12:10 GMT

The easiest way to do this is through code, since it's more flexible and you
can merge/concatenate the UserName fields however you want. Having said this,
when is the UserList field filled? That is, where did you put the rule to
fill this field?
---
S.Y.M. Wong-A-Ton

> I have a group called "TeamMembers". In that group I have a string field
> called "UserName" I have a field that is not in that group called "UserList"
[quoted text clipped - 4 lines]
> The rules I have created so far only return the first "UserName" item in the
> group.

Reply to this Message

fbartrom - 10 Mar 2006 14:27 GMT

I have a command button that creates a document workspace using the DWS web
service in SharePoint. I was planning for one of the rules on this command
button to perform the concatenation of the UserName fields. I want to do
this because one of the options on the web service that creates the document
work space is to pass it a user list string so the newly created site will be
populated with the members. I need to be able to to concatenate the
usernames with some additional formatting into a single string to pass to the
web service. The additional formatting is not a problem. I am not having
success concatenating the UserName fields.

> The easiest way to do this is through code, since it's more flexible and you
> can merge/concatenate the UserName fields however you want. Having said this,
[quoted text clipped - 11 lines]
> > The rules I have created so far only return the first "UserName" item in the
> > group.

Reply to this Message

S.Y.M. Wong-A-Ton - 12 Mar 2006 14:24 GMT

I don't know of any InfoPath or XPath function that can concatenate strings
over a node-list, just like the sum() and avg() function can do for numbers.
Unless the amount of members is static, i.e. you always have e.g. 10 members
in the list, I cannot think of any other way to do it than through code. Is
the amount of members static or does the amount vary?
---
S.Y.M. Wong-A-Ton

> I have a command button that creates a document workspace using the DWS web
> service in SharePoint. I was planning for one of the rules on this command
[quoted text clipped - 21 lines]
> > > The rules I have created so far only return the first "UserName" item in the
> > > group.

Reply to this Message

fbartrom - 13 Mar 2006 15:08 GMT

The amount of members will vary.

> I don't know of any InfoPath or XPath function that can concatenate strings
> over a node-list, just like the sum() and avg() function can do for numbers.
[quoted text clipped - 29 lines]
> > > > The rules I have created so far only return the first "UserName" item in the
> > > > group.

Reply to this Message

S.Y.M. Wong-A-Ton - 13 Mar 2006 16:27 GMT

In that case, the only option I see right at this moment is to code it:
Retrieve the group node for the members and then loop through all the child
nodes and concatenate the user names.
---
S.Y.M. Wong-A-Ton

> The amount of members will vary.
>
[quoted text clipped - 31 lines]
> > > > > The rules I have created so far only return the first "UserName" item in the
> > > > > group.

Reply to this Message