Newbie Questions

Re: Submit problem with MAX()

Mohammad Iqbal Basha — Fri, 20 Jan 2012 08:11:44 GMT

Hi Tonydotigr,

Even I had the same issue. I am able to resolve it. The reason for getting such error message is with the Form library limitations.

To solve this issue, perform these below steps.

1. Open Form library where you published your Infopath form.

2. Go to Modify View option.

3. Go to Item Limit. There you will find the Text box.

Change the item limit option according to your requirement.

That will resolve your issues.

Regards,

Basha

Re: Submit problem with MAX()

tonydotigr — Fri, 13 Jan 2012 15:31:03 GMT

There was a non-number placeholder that was messing things up. Once this was removed records were able to be created. Still doesn't sort correctly, but converting to number should fix this.

Thanks all!

Re: Submit problem with MAX()

Jimmy — Tue, 10 Jan 2012 15:10:01 GMT

It just doesn't make sense that it would do that on account of the datatype.

Have you tried displaying the list's data in your form to see what values are there? Does it display ID values of 1000 and above? Maybe you've hit some limit for the maximum number of rows that can be returned.

Re: Submit problem with MAX()

tonydotigr — Tue, 10 Jan 2012 14:17:24 GMT

Because the way its being sorted in the list and keeps trying to duplicate creating record "1,000" which appears on the top of the list. Prior the ID_Num field was setup as a string, but need converted to integer.

Re: Submit problem with MAX()

Jimmy — Tue, 10 Jan 2012 13:13:08 GMT

Why is it that you believe you need to convert them to integers? Is it because they have commas or a decimal portion in them?

Re: Submit problem with MAX()

tonydotigr — Tue, 10 Jan 2012 12:41:26 GMT

That could be true, but I need a way to convert the stored string values to integer. After 1,000 the MAX() alone stopped working.

Re: Submit problem with MAX()

Jimmy — Tue, 10 Jan 2012 05:16:51 GMT

You shouldn't be using the number() function there. That may very well be the problem.

Re: Submit problem with MAX()

tonydotigr — Tue, 10 Jan 2012 01:14:56 GMT

If I can't get this function to work is there a way to easily import...

Submit problem with MAX()

tonydotigr — Mon, 09 Jan 2012 20:39:47 GMT

Recently ran into a problem with an InfoPath form. Using ‘max(@ID_Num) + 1’ to submit the form returns error ‘The form was not submitted because a form named 1000.xml already exists in the document library at **** Library. Please contact the provider of the form' when submitting to a SharePoint list. I believe the problem is the field in reference (ID_Num / string) on SharePoint List needs to be converted to an integer for the submit function to work properly. Though I don't seem to have access on List to do this. Was trying to use the function below, but InfoPath does not like.

max(number(@ID_Num)) + 1

Any ideas would be appreciated!