Limiting Number of Rows in a Repeating Table - InfoPath Dev
in

InfoPath Dev

Limiting Number of Rows in a Repeating Table

Last post 02-08-2017 07:38 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 02-08-2017 05:36 AM

    Limiting Number of Rows in a Repeating Table

     I have been researching and attempting other solutions to this issue, and I know it has been answered in the past, but I wanted to share the solution I came up with.

     I created a dual approach for this, which includes allocating one of the fields in the repeat table to be an autonumber field, then placing a rule on the entire repeat table, that if 'NumberingField' = (max number of rows #), then do not allow users to enter new row checkbox.  This is a simple way to do this without having to export and change the maxoccure.

     

     

    When creating repeating table, allocate a column for ‘auto number’ ; make the field a calculated field (Field1 as Example), and use this rule in the field: count(preceding-sibling::*) + 1

    • Create a format rule on the entire repeating table, and then put condition that ‘Field1 = 4 (The Max # of Lines that i wanted as example.)

    • Choose control ‘Don’t allow users to insert or delete this control’

    • People can add up to the maximum you want, then trying to click the button, it just won’t let them add. 

     

  • 02-08-2017 07:38 AM In reply to

    Re: Limiting Number of Rows in a Repeating Table

     Awesome - thanks for posting! :)

    Hilary Stoupa

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