Collating data from fields within repeating section and dump into rich text box - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Collating data from fields within repeating section and dump into rich text box

Last post 08-08-2011 11:34 PM by Patrick Halstead. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 08-03-2011 04:11 PM

    Collating data from fields within repeating section and dump into rich text box

    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.
  • 08-06-2011 04:02 AM In reply to

    Re: Collating data from fields within repeating section and dump into rich text box

    really any help at all would be greatly appreciated
  • 08-08-2011 03:53 PM In reply to

    Re: Collating data from fields within repeating section and dump into rich text box

    Second Bump
  • 08-08-2011 04:26 PM In reply to

    Re: Collating data from fields within repeating section and dump into rich text box

    You'll need to use code for this, I imagine, since rich text is XHTML - otherwise, I'd suggest using a double eval formula. Here's a link to a blog post that may help you with this.

    Hilary Stoupa

  • 08-08-2011 11:34 PM In reply to

    Re: Collating data from fields within repeating section and dump into rich text box

    Hi Andrew,

    Thanks for downloading qRules. We do offer application development services and would be happy to get the code written for you. Let me know.

     

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.