Access Repeating table and specify value within cell in each row - InfoPath Dev
in

InfoPath Dev

Access Repeating table and specify value within cell in each row

Last post 02-17-2013 01:30 PM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-07-2013 07:32 AM

    • stara
    • Top 200 Contributor
    • Joined on 10-20-2010
    • Posts 54

    Access Repeating table and specify value within cell in each row

    Hi,

    I'm able to create 3 rows in a repeating table within repeating section. Now I'd like to auto-populate values for a specific cell in each row.

    For eg: Table has 3 rows and 3 columns. i'd like to set the values in the following cells: column 1 row 1, column 1, row 2, column 1 row 3

    The fields are connected to Access database.

    Can any one provide code for this?

     

     Thanks so much

     

     

  • 02-17-2013 01:30 PM In reply to

    Re: Access Repeating table and specify value within cell in each row

    Hi Stara,

    You just need a filtered set field action. You do not need code for this. We've talked about this many times in our webinars.

    To create a filtgered set field action. Just add a rule that sets the field for the column that you want to set.

    Then, go to File->Publish->Export Source Files and create a new folder to export the source files. Close InfoPath Designer down. Open the manifest.xsf saved in the folder using notepad. Scroll down to the rulesets area and find the rule you just added. Add square brackets [] around the target field that you want to filter. Inside the square brackets you'll want to add the dynamic field condition that will control which rows get set. If you need help with this, send email to us. I also recommend looking at the qRules command SetValue: http://www.infopathdev.com/files/folders/qrules/entry53164.aspx

    Good luck! 

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