in

InfoPath Dev

Transfer Data from Repeating Table to a Repeating Section

Last post 12-19-2007 08:04 PM by Clay Fox. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 11-07-2007 03:15 PM

    • Patrick
    • Top 75 Contributor
      Male
    • Joined on 11-03-2007
    • Texas
    • Posts 51

    Transfer Data from Repeating Table to a Repeating Section

    Ok, I don't know if this is possible, but here's the scenario:  The naming convention I have used here is for ease of communication...

     My goal in doing this is to have one person enter data in a view, and another person edit/review/add to the original data in a separate view.  The trick is that each view displays the information in different ways, (hence the table and section).

     

     I have a form with multiple views.  In "View A" I have a repeating table with many columns.  In "View B" I have a repeating section with multple groups and fields residing within.  My thought is that I want to have someone enter data (such as an address) in "View A" in the repeating table, (adding rows as they go along), and switch to "View B" where the data (addresses) will be duplicated. 

     So, "Address1_RepeatingTable" in row1 of the repeating table will appear in the control "Address1_RepeatingSection" in the repeating section, and "Address2_RepeatingTable" in row2 of the repeating table will appear in the control "Address2_RepeatingSection" in the repeating section.

     I have tried to set the default value of "Address1_RepeatingSection" to the value in "Address1_RepeatingTable", which works for the first entry.  Every time I insert another section while testing the form in preview mode, each additional section's "Address1_RepeatingSection" value is the same as the section before. 

     How can I get row1, row2, row3... of the repeating table to correspond with section1, section2, section3... of the repeating section?  I hope I didn't make my explaination too wordy or confusing.  Does anyone have any suggestions? 

     Maybe someone knows of another way...?

    -Patrick
  • 11-07-2007 07:30 PM In reply to

    Re: Transfer Data from Repeating Table to a Repeating Section

    Ok trying to follow this...

    Data in your form is persistent, views are just ways of representing the information with controls.

    You should have one repeating group of fields with information.

    In View A you would have a repeating table bound to the repeating group, in View B you would have a repeating section with controls bound to the same repeating group.  Same information, two ways of representing it.

    Whatever is entered in one would show in the other because they are both referencing the same data.

    It sounds like right now you are using two sets of data which is unneccessary.

    Hope this helps.

  • 11-08-2007 09:28 AM In reply to

    • Patrick
    • Top 75 Contributor
      Male
    • Joined on 11-03-2007
    • Texas
    • Posts 51

    Re: Transfer Data from Repeating Table to a Repeating Section

    Great!  It works perfectly!  Thanks so much :)

    -Patrick
  • 12-19-2007 07:16 PM In reply to

    Transfer Data from Repeating section to a Repeating Section

    i want to transfer data from repeating section to another repeating secion which is in another infopath form!

     

  • 12-19-2007 08:04 PM In reply to

    Re: Transfer Data from Repeating section to a Repeating Section

    This would be pretty tricky but probably possible via code.

    Typically you would use a database or even save the data as XML from the first form and then have the second from pick it up and use it.

Page 1 of 1 (5 items)
Copyright © 2003-2007 Qdabra Software. All rights reserved.
View our Terms of Use.