InfoPath Dev

Hello

Can anyone assist with how I can get/list all numbers between and including two numbers?

eg. user enters start number: 1 and end number: 50. I need to get 1, 2, 3, 4, 5....50

Where would the list of numbers get stored?

I'm thinking custom code (or qRules) might be needed for this, but please explain how the list of numbers will be stored or used, to see if there's a non-code solution.

Thanks.

Hi Ernesto

The numbers need to be exported and used to create seperate items in another list.

Basically, we have a central admin role which allocates groups of eTickets to a site admin.  The site admin will then allocate eTickets to individuals.

Infopath will provide the UI and the information will be stored in Sharepoint.

ErnestoM:

Where would the list of numbers get stored?

I'm thinking custom code (or qRules) might be needed for this, but please explain how the list of numbers will be stored or used, to see if there's a non-code solution.

Thanks.

Hi Ernesto

 To clarify further, at this point if I could just get all the integers, including start and end, concatenated in a text field, I'm sure that will suffice.  We then have Nintex Workflow which hopefully can extract all the integers into a collection and then using that collection, create the items in an eTicket list (custom Sharepoint List).

 Thanks

 Here is (sort of) a solution. It works, but the problem is that InfoPath only allows a certain number of iterations to happen in the form rules. It seems that the difference between start and end can only be around 15 or 16. Anything larger and I get an error.

Maybe it helps you to dig deeper for a better solution, though I'm thinking code or qRules might be needed to make this more efficient.

Thank you so much! That's a great start.