Hi there,
we have an Infopath form we use for gathering data needed for creating and populating a Google Apps account.
Currently the Form is working perfectly on our Sharepoint 2010 server and works as intended (there isn't much to it).
The form contains a Repeating section which we use to document user data (username, firstname etc etc).
This repeating section is inside another repeating section used to break up the data into the different domains needed to be setup for the client.
In the user data repeating section I have created a field (which I will call a GAM field) which pulls data from these various user data fields - concat("gam create user ", field67, " firstname ", field65, " lastname ", field66, " password ", field69)
This field also works perfectly.
The issue I have is I want to collate all these "GAM fields" into one textbox down the bottom of the domain repeating section so all we need to do is copy the bottom text box which will contain all the command codes for creating the Google Apps users.
In a visual sense:
{------DOMAIN_1----------------}
-------------USER 1----------------
[USER NAME FIELD]
[FIRST NAME FIELD]
[LAST NAME FIELD]
[GAM FIELD = CODE AS ABOVE]
--------------------------------------
-------------USER 2----------------
[USER NAME FIELD]
[FIRST NAME FIELD]
[LAST NAME FIELD]
[GAM FIELD = CODE AS ABOVE]
--------------------------------------
--------AT BTM OF SECTION-----
[RICH TEXT BOX=
USER1_GAMFIELD
USER2_GAMFIELD
--------------------------------------
{------/DOMAIN_1----------------}
{------DOMAIN_2----------------}
-------------USER 1----------------
[USER NAME FIELD]
[FIRST NAME FIELD]
[LAST NAME FIELD]
[GAM FIELD = CODE AS ABOVE]
--------------------------------------
-------------USER 2----------------
[USER NAME FIELD]
[FIRST NAME FIELD]
[LAST NAME FIELD]
[GAM FIELD = CODE AS ABOVE]
--------------------------------------
--------AT BTM OF SECTION-----
[RICH TEXT BOX=
USER1_GAMFIELD
USER2_GAMFIELD
--------------------------------------
{------/DOMAIN_2----------------}
Obviously as these GAM fields are from a repeating section I don't know how to select them as a value.
Additionally each GAM Field down the bottom in the rich text box needs to be on its own line.
I have been told I need to filter the specific GAM fields but I really wouldn't know where to start
I hope someone out there can help me, if we can get this to work it will save us alot of time.