How do I create a sequential list in an InfoPath form based on an initial input into a table.

I am trying to provide a form where the user will set the initial value and the form will set the next 24 values incrementing by one each.

I've used a table with a formula adding 1 to the previous row and receive the following error: "...The number of calculations used for a single action exceeded the maximum limit."

It appears that after 15 iterations InfoPath kicks out this error. See the attached files for a screen shot of both the message and the portion of the form in question.

Thank you
InfoPathCalcErr.JPG
InfoPathCalcErr2.JPG
JaemoeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Clay FoxDirector of Business IntegrationCommented:
not sure whether these rows exist or you are inserting them.
I often use a field in the form called currentrow or maxrow to both start the sequence and keep track of the next number.
Then on insert, I have the new row default be maxrow+1.  Quick and dirty is break up your rules to two fields to get around the limit. One does the first 12 and the other does 13 on.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JaemoeAuthor Commented:
I will accept this as a solution with one note and one key addition:

Note - when adding the field for determining the max value, the syntax is max() not maxrow

additionally - in order to keep the values from all changing as rows are inserted the "Update this value when the result of this formula is recalculated." MUST be unchecked, see the attached screen shot.

As for a static list... I used one rule updating all 25 fields upon initial input into the first field. I.E. when the first field "is not blank" field2=field1+1, field3=field1+2, field4=field1+3... and so on.
SequenceFieldSetting.JPG
0
JaemoeAuthor Commented:
See author's comments for important additions to Expert solution.

Thanks again for the input clayfox
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
InfoPath

From novice to tech pro — start learning today.