Newbie Questions

Re: limiting the number of repeating sections based on condition

Shiva — Tue, 30 Dec 2008 07:34:02 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 > 2)

{

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

eventObj.ReturnStatus = false;

}

Re: limiting the number of repeating sections based on condition

Skarn — Wed, 24 Dec 2008 23:34:46 GMT

ok, your remaining problem is how to let users delete a row seeing as you have disabled the built in delete options.

Add another column to your repeating table (this sometimes creates a new field in your datasource,so don't forget to delete it) and put a button in the column (I usually put a lowercase x on it to indicate 'delete')

Now right click the button and go to 'Edit code behind button'.

Now paste the following standard code to delete a repeating section/table row from a button like this:

//[Jscript]

var thisNode = eventObj.Source.selectSingleNode(".");
thisNode.parentNode.removeChild(thisNode)

You can use this code without modification in any button in a repeating section or table and it will delete the repeating section or table that the button resides in!

Good luck, merry christmas!

Re: limiting the number of repeating sections based on condition

VadimS81 — Thu, 18 Dec 2008 19:47:27 GMT

Thanks for the help, unfotunatly it won't work for me because I need the limit to be based on condition. Depending on what is selected the limit needs to change.

Thank you

Re: limiting the number of repeating sections based on condition

Jimmy — Thu, 18 Dec 2008 00:31:42 GMT

The easiest way to do this is:

Save the template as its source files
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

Re: limiting the number of repeating sections based on condition

ErnestoM — Wed, 17 Dec 2008 23:50:42 GMT

Interesting dilemma, since InfoPath's built in Conditional Formatting options group together insert/delete (i.e. "Don't allow users to insert or delete this control").

Re: limiting the number of repeating sections based on condition

VadimS81 — Wed, 17 Dec 2008 23:10:19 GMT

Thanks, the only problem is that I want users to be able to remove the rows.

Re: limiting the number of repeating sections based on condition

warrtalon — Wed, 17 Dec 2008 22:16:32 GMT

Ernesto, that works very well and limits it to 3 as an example. Nice work and very simple.

Re: limiting the number of repeating sections based on condition

ErnestoM — Wed, 17 Dec 2008 22:08:59 GMT

Attaching 2007 version too.

Re: limiting the number of repeating sections based on condition

ErnestoM — Wed, 17 Dec 2008 22:08:22 GMT

Hello, attached you'll find a form that I think accomplishes what you're trying to do.

Re: limiting the number of repeating sections based on condition

warrtalon — Wed, 17 Dec 2008 21:31:18 GMT

Well, I know that you can count and total fields in a repeating table, so I think we still need to focus on that. As for your overall goal, I have never tried to do such a thing, so I am just trying to help you troubleshoot the individual issue that seems to be keeping you from your goal.

I'll need more details and the exact method by which you are trying to count fields in your repeating table.

Re: limiting the number of repeating sections based on condition

VadimS81 — Wed, 17 Dec 2008 21:24:48 GMT

Tried that, does not seem to work either. is there maybe some other way to limit number of repeating rows based on condition.

Thanks

Re: limiting the number of repeating sections based on condition

warrtalon — Wed, 17 Dec 2008 21:19:55 GMT

I don't think you can count the section itself. You need to count one of the nodes (fields) inside the repeating table, and they probably have to be populated, since a null value may not add to the count.

Re: limiting the number of repeating sections based on condition

VadimS81 — Wed, 17 Dec 2008 21:18:06 GMT

I am just trying to add a rule like this count(.) > 2. dot is a repeating section that I am trying to count.

Thank you

Re: limiting the number of repeating sections based on condition

warrtalon — Wed, 17 Dec 2008 21:01:29 GMT

What are you setting the count function to? Which field? Are you populating the fields that are being counted?

limiting the number of repeating sections based on condition

VadimS81 — Wed, 17 Dec 2008 20:51:05 GMT

Hello,

I am trying to limit the number of rows allowed based on a condition. I have tried to do it with the rules, however when I do count(), I always seem to get 1 as a result no matter how many rows I have.

Thanks a lot,

Thank you