Copy Repeating Table data to NON repeating fields - InfoPath Dev
in

InfoPath Dev

Copy Repeating Table data to NON repeating fields

Last post 05-22-2013 07:00 AM by BejeweledOne. 7 replies.
Page 1 of 1 (8 items)
Sort Posts: Previous Next
  • 05-21-2013 10:45 AM

    Copy Repeating Table data to NON repeating fields

    Ok, guys I am stumped here. I have been reviewing all the posts about copying repeating table data to repeating sections and repeating tables and have tried following some of the solutions but am stymied. My Form has a repeating table with a drop down list. In that list are 4 items. So there could be up to 4 table rows.


    What I need to do is get the value from the drop down list in each row that is inserted and populate it into a static non-repeating field. I have 4 field, one for each possible instance of the repeating table row. Here is where I get confused. I don't know if I need to use a rule or a set the value of each of the non-repeating fields to match the value of an instance of the table row.


    And if I set the value of the non-repeating fields would I use tablesrc and rowsrc?


    HELP!
  • 05-21-2013 11:40 AM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    Hi-

    I'm not sure whether qRules is needed. A default value would probably work.

    For my:myFields/my:dropdown1, the default value is my:myFields/my:containergroup/my:repeatinggroup[1]/my:dropdown
    For my:myFields/my:dropdown2, the default value is my:myFields/my:containergroup/my:repeatinggroup[2]/my:dropdown

    Etc.

    Does that make sense?

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-21-2013 11:56 AM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    It makes quite a bit of sense but doesn't seem to work unless I am doing something wrong. I am setting the default value in the non-repeating field where I want to capture the data from the repeating field.
  • 05-21-2013 12:01 PM In reply to

    Re: Copy Repeating Table data to NON repeating fields

     Yes, you are correct in setting the default value on the non repeating field.

    How is it not working? (can you describe further?) Or perhaps attach your form.

    Thanks.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-21-2013 12:22 PM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    I have attached the form. You can see in the bottom debug section 8 fields. These fields will capture the data from the two drop down lists in the main portion of the form. In the first two I have set the default value as indicated and when I select the items in the drop down those field do not change to reflect the correct value.


    Thanks to Hilary for the wonderful work with the bullet-ted list.
  • 05-22-2013 05:42 AM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    It looks like you entered the xpath as a literal string in the default value. Is that what you meant to do?


    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-22-2013 05:43 AM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    You'll need to make sure it's entered as a formula.


    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-22-2013 07:00 AM In reply to

    Re: Copy Repeating Table data to NON repeating fields

    I had a problem trying to enter it as a formula and kept getting an error so I tried it the other way. Now I see what I did wrong and it IS working correctly! YAY! Thank you, thank you, thank you................... You guys rock!
Page 1 of 1 (8 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.