Controls

Re: How to Limit number of repeating section

Patrick Halstead — Tue, 01 Dec 2009 01:37:12 GMT

Modify the schema to add maxOccurs attribute to the node. You'll have to save as source files. Open up the XSD. Find the node and insert maxOccurs on it. Then save and right click manifest.xsf to get back into Design mode so you can publish with the manually tweaked schema.

Ain't InfoPath wonderful! :)

Funny! That's the same thing Jimmy recommended. :)

Re: How to Limit number of repeating section

aberya — Tue, 01 Dec 2009 01:20:16 GMT

Yeah I tried that as well, but found that when you hit the limit the user cannot delete any sections. It would be good in sone cases but I needed to stop users from adding new items. Its a pity the condition is both insert and delete and not seperated.

In actual fact if you limit your forms to Browser based forms only, Form Services does display a nice error message when the XSD Schema has an upper bounds so you don't need to do anything other than that, its when you want a form to be edited in InfoPath when it displays the user unfriendly message.

Re: How to Limit number of repeating section

Karsten Brocksieper — Mon, 30 Nov 2009 22:41:35 GMT

Hello @all,

I don´t know if I misunderstood the above mentioned problem but why can´t you just use an expression like

Expression: count(my:field1) >= "3"
Condition: Don´t allow users to insert or delete this control ==> Activate

In my opinion that´s the easiest way to limit the number of sections that can be inserted.

Regards,

Re: How to Limit number of repeating section

aberya — Mon, 30 Nov 2009 21:19:11 GMT

It doesn't look like you can alter the error message that InfoPath displays when using Browser enabled forms, well without using code. What I have done in the past is to display an expression box with the error message desired and set conditional formating to display only when the number of occurences of the reapeating section is equal to the maximum. You still get an error message if you add another section, but better than what InfoPath provides out of the box. I tried adding a conditional format on the section to not allow adding once the number of ocurrences was at the maximum but that didn't work because it stops the user from removing sections as well.

Re: How to Limit number of repeating section

Thilakraj — Fri, 06 Feb 2009 18:43:00 GMT

Hello, I'm using browser enabled form, so I believe I can’t use the above script. Is there any other way to limit the repeating section in browser enabled forms?

Thanks,

Thilakraj

Re: How to Limit number of repeating section

Shiva — Fri, 06 Feb 2009 02:58:34 GMT

Hello,

You have to add on before change event for that field then you have to check the number of nodes available in that list. If the count is exceeds your requirement then you to give one alert message and eventObj.ReturnStatus = false;

Depends on your requirement you have to write the code and here is the sample,

function msoxd_my_field2::OnBeforeChange(eventObj)

{

var repeatingNodes = XDocument.DOM.selectNodes("/my:myFields/my:group1/my:group2");

if(repeatingNodes.length > 3)

{

XDocument.UI.Alert("Exceed the nodes");

eventObj.ReturnStatus = false;

}

Note: If you want to set the message 'eventObj.ReturnMessage = "your message".

Re: How to Limit number of repeating section

Thilakraj — Fri, 06 Feb 2009 00:31:13 GMT

Jimmy Rishe,

Thanks for the quick reply.. I tried your suggestion but when the user try to add the 4 th section, infopath is not showing user friendly error message.. it shows "Infopath cannot insert the section or row because of an error". Is there anyway to customise this error message and show user friendly message to the user?

Thanks,

Thilakraj

Re: How to Limit number of repeating section

Jimmy — Fri, 06 Feb 2009 00:12:30 GMT

I know of no way to accomplish this in the InfoPath designer, but for a fixed number (in your case 3) this is probably the easiest way to accomplish that:

Save the template as its source files (from the File menu in the InfoPath designer)
Open the schema (XSD) file in a text editor
Find the line that refers to your repeating field and change the maxOccurs value from "unbounded" to the number you want
Save the schema
Right-click manifest.xsf and select Design
Re-save the template

How to Limit number of repeating section

Thilakraj — Thu, 05 Feb 2009 23:45:28 GMT

Hi,

I need to restrict user to insert max of 3 repeating section in the infopath form.

User should not be able to add more than 3 repeating section.

Can I do this through rule?

- Thilakraj