Controls

Re: Limit amount of repeating table rows that can be created

Stuart Shutts — Wed, 08 Feb 2017 13:30:14 GMT

I created a dual approach for this, which includes allocating one of the fields in the repeat table to be an autonumber field, then placing a rule on the entire repeat table, that if 'NumberingField' = (max number of rows #), then do not allow users to enter new row checkbox. This is a simple way to do this without having to export and change the maxoccure.

When creating repeating table, allocate a column for ‘auto number’ ; make the field a calculated field (Field1 as Example), and use this rule in the field: count(preceding-sibling::*) + 1

Create a format rule on the entire repeating table, and then put condition that ‘Field1 = 4 (The Max # of Lines that i wanted as example.)
Choose control ‘Don’t allow users to insert or delete this control’
People can add up to the maximum you want, then trying to click the button, it just won’t let them add.

Re: Limit amount of repeating table rows that can be created

mwallebeck — Thu, 11 Sep 2014 19:45:26 GMT

Hey there. Sooo... I have a similar issue as above. I am not creating a form from scratch out of infopath. I have to work with the form template from the sharepoint server. Having said that, it is a web based form and I cannot find a way to limit the number of rows in the repeating table in the schema file without creating an error when it opens from the Sharepoint list. Do you know if this feature is enabled in a web form? Thanks! *EDIT: So I have been messing around with is a little more. When ever I publish the form to the sharepoint server, somehow the schema file variable gets changed back from 3 to unbounded. Does anyone have an idea how to prevent this from happening.

Re: Limit amount of repeating table rows that can be created

Patrick Halstead — Sun, 18 Aug 2013 23:35:55 GMT

Beautiful!

Re: Limit amount of repeating table rows that can be created

ShivaKalluri — Thu, 15 Aug 2013 19:13:06 GMT

Hi, I found a way to customize the message you see in the alert box after maxOccurs property is changed in the schema.xsd file. However, this I tested in browser enabled forms only. The OOB message that gets displayed in the alert box comes from a variable "k_strValidationMaxChildCountFormat " in a javascript file called "IntlCoreStrings.Js". This can be overwritten using the below code. Put this code in Form Loading event of form's code behind. The default message is "A new item could not be inserted. In this form only a maximum of {0} items is allowed.". In the below example I replaced it with "Test{0}". string strScript = "IntlCoreStrings.k_strValidationMaxChildCountFormat = \"Test{0}\";"; Page pgCurrent = HttpContext.Current.Handler as Page; if (pgCurrent != null) { ScriptManager.RegisterStartupScript(pgCurrent, pgCurrent.GetType(), "Alert", strScript, true); return; } Make sure you add the references for the System.Web and System.Web.Extentions assemblies in you solution. Also, the using tags for System.Web and System.Web.UI. I know I replied very late. But, this can help others who comes here for a solution :) Thanks, Shiva

Re: Limit amount of repeating table rows that can be created

Hilary Stoupa — Mon, 11 May 2009 15:55:19 GMT

Hi, Elsa -- welcome to the forum.

As far as I know, there is no upper limit. The schema for the repeating group says that the max is 'unbounded', which means.... no upper limit. Keep in mind that as your xml file increases in size (which will happen as new groups are inserted) you may eventually see some performance issues for that xml file.

Re: Limit amount of repeating table rows that can be created

Elsa Alves — Mon, 11 May 2009 15:38:58 GMT

Hi Hilary,

I was searching for information about the limit of repeating sessions and i found this forum, it looks you're an expert on the subject. What i need to know is the opposite of the above. Do you know the standard limit of rows for repeating sessions, i mean, if we don't impose a limit, does Infopath have "standard" limit of rows that can be inserted?

Thank you very much

Elsa

Re: Limit amount of repeating table rows that can be created

Anonymous — Wed, 05 Nov 2008 16:43:19 GMT

Genius - it works! Thanks so much again.

As you've been such a great help, maybe you could look at another query I've posted on here - I've had some help from another person in the forum but they were working on IP2007 so I've come up stuck again. Again, it's not a life or death thing but something that would really improve the functionality of my form.

http://www.infopathdev.com/forums/p/9483/33748.aspx#33748

Cheers!

Re: Limit amount of repeating table rows that can be created

Hilary Stoupa — Wed, 05 Nov 2008 15:21:53 GMT

You aren't a pain at all! Export the source files. Close the form. Change the schema file in the folder with your source files. Open manifest.xsf in your source files in design mode, and 'Save As' a new .xsn to basically 'repack' those source files up in a template..... make sense?

Re: Limit amount of repeating table rows that can be created

Anonymous — Wed, 05 Nov 2008 13:07:11 GMT

Hmmm, think I must be doing something wrong here. I'm using IP 2003 and don't have any options to "Save" my form as source file - only the option to export the source files. I can do that and then alter the schema but it doesn't change the way the form works - presumably they're no longer "joined" after I export the source files?

Hate to be a pain but it would make my life easier if I could sort this out :)

Re: Limit amount of repeating table rows that can be created

Hilary Stoupa — Fri, 31 Oct 2008 18:37:43 GMT

After you saved as source files, did you close your form? If the form is still open, it is 'using' those form files, like the schema, so they will open read only....

Re: Limit amount of repeating table rows that can be created

Anonymous — Fri, 31 Oct 2008 17:33:17 GMT

Hi Hilary, I am attempting to do the same thing on a form I have designed. I've exported the source files and opened myschema.xsd in notepad so I can set the "maxOccurs" however when I try to save or exit the schema I get an error message saying it cannot create file and to check the file name and path are valid....any ideas?

Re: Limit amount of repeating table rows that can be created

jrudolph — Fri, 19 Sep 2008 19:32:38 GMT

okay well thanks anyways. I like this method, and it is probably going to be rare that the message pops up anyways.

Re: Limit amount of repeating table rows that can be created

Hilary Stoupa — Fri, 19 Sep 2008 19:30:42 GMT

I'm sorry, I don't know of a way to change the message. It is ugly, isn't it! I imagine there is a way in code....

Re: Limit amount of repeating table rows that can be created

jrudolph — Fri, 19 Sep 2008 18:22:29 GMT

I cant seem to find the "counter" control or formating.

I am building a web enabled form does that matter?

Never mind I figured it out, use the "count" function as part of the default settings.

Re: Limit amount of repeating table rows that can be created

jrudolph — Fri, 19 Sep 2008 18:16:57 GMT

Thanks Hilary, that works great. Do you know if there is a way to change they type of message that appears?