Repeating Subforms Incrementally

[Former Community Member]

This is going to sound kind of funky...



We have a business requirement that a repeating subform ONLY repeat in multiples of 5. The subform is a column that counts five times across a page horizontally. Our form can never have more or less than 5 columns across any page, not matter how many of the have data.



For instance, if our data should only need 8 columns to fill, the form should build 2 sets of 5 columns (which are on seperate pages). The five on the first page would be filled and the first three on the second page would be filled. That would leave to empty columns on the second page.



Here's the real kicker. Our business requirements forbid us from using JavaScript or FormCalc. We have to do it via form object settings. Does anyone have ANY ideas on how to possibly go about doing this?



Thank you so much for any help! If this is unclear or it would be easier to solve with conversation, feel free to email me.



Ryan D. Lunka

Cardinal Solutions Group

rlunka@cardinalsolutions.com

[Former Community Member]

I do not see how you can do this without scripting. The product will only allow you to grow the number of rows based on the amount of data being merged onto it (8 rows in the data equals 8 rows in the form). You could add to empty rows in the data that would drive the additional rows on the form. This would mean you woudl have to massage the data before doing the merge operation.

[Former Community Member]

Ok. We actually did manage to figure it out. For reference here's what we did:



Instead of setting up the columns as one repeatable subform, we put all 5 columns on as seperate (not repeatable) items. We used the same id for all 5 of them so they auto-index themselves as (column[0], column[1], etc). Then we bound the schema to the fields in all 5 of the columns. So each field in each column had a binding to node.repeatableNode[*].whatever_value. Then the larger subform that all of those columns reside in, is set to repeatable.



LiveCycle automatically fills those "columns" one at a time because of their indexing. When it gets past five, it repeats the entire subform (which HAS to have five columns) but only fills the neccesary columns as it continues.



Ask a funky question, get a funky answer. But it works.



Ryan D. Lunka

Cardinal Solutions Group

rlunka@cardinalsolutions.com