Controls

Re: Checkbox Validation - Repeating Table - IP2013

LarryTremaine — Mon, 03 Oct 2016 14:42:03 GMT

Please refer to image. I'm sure someone has brought up this before, but I can't find it anywhere. Much appreciated.

Re: Checkbox Validation - Repeating Table - IP2013

Hilary Stoupa — Wed, 28 Sep 2016 15:45:12 GMT

Sorry! I attached the wrong one. :)

Re: Checkbox Validation - Repeating Table - IP2013

LarryTremaine — Wed, 28 Sep 2016 15:42:11 GMT

I was hoping for the Checkbox sample that Bre attached in her 06-05-2015 11:37 AM reply. Your example is just a handful of texboxes. Hoping to see a 2010 version of this: Attached is an example that uses a secondary data source for some helper fields to evaluate the repeating table. Thanks ... much appreciated

Re: Checkbox Validation - Repeating Table - IP2013

Hilary Stoupa — Wed, 28 Sep 2016 15:03:27 GMT

Here is a copy of the original sample saved as IP 2010. Hope it helps!

Re: Checkbox Validation - Repeating Table - IP2013

LarryTremaine — Wed, 28 Sep 2016 14:50:01 GMT

Do you have an example that works in 2010? This looks to be very similar to the problem that I am having. It occurs whether I use a Repeating Table or a Repeating Section. Only two controls in the repeating section: checkbox and textbox. Only rule is that if checkbox is checked then the textbox must be non-blank. 1. Works fine in first element when nothing has been repeated. 2. Add a item so now there are two, each with checkbox and textbox. 3. If both checkboxes unchecked ... fine 4. If both checkboxes checked and both have the non-blank textboxes ... fine 5. Element One is checked and has something in its textbox. Element Two is not checked (so therefore its empty textbox value should be ignored) ... failure. Get 'textbox is missing its value' error message courtesy of my validation rule. It appears that Sharepoint is looking at the checkboxes as a collection of two and validating each element against that collection. It isn't honoring the fact that each repeating section/row owns its own checkbox. It isn't ignoring the other checkboxes when validating each element.

Re: Checkbox Validation - Repeating Table - IP2013

JKnox — Thu, 11 Jun 2015 17:18:46 GMT

My checkbox is on the Main Datasource ( I double checked).

Re: Checkbox Validation - Repeating Table - IP2013

Bre Huston — Wed, 10 Jun 2015 16:42:24 GMT

It looks like the checkbox is in your secondary data source. It will need to be in the main data source for the logic.

Re: Checkbox Validation - Repeating Table - IP2013

JKnox — Tue, 09 Jun 2015 17:54:41 GMT

Logic does not work in preview. Check box xpath: /dfs:myfields/dfs:datafields/my:SharePointListItems_RW/my:field1 What formula are you referencing? The one you suggested in the previous solution above?

Re: Checkbox Validation - Repeating Table - IP2013

Bre Huston — Tue, 09 Jun 2015 15:22:57 GMT

Not a problem we just have to get creative. Does the logic work in preview? Can you also paste the xpath to your check box here and also the formula from your form?

Re: Checkbox Validation - Repeating Table - IP2013

JKnox — Tue, 09 Jun 2015 11:12:05 GMT

I am unable to attach a copy of the form (Security reasons). It is a repeating section and yes it is bound to the main data source. Form will not publish.

Re: Checkbox Validation - Repeating Table - IP2013

Bre Huston — Mon, 08 Jun 2015 22:56:42 GMT

Can you attach a copy of your form? Also - is the repeating table bound to the main data source? The form should publish without errors.

Re: Checkbox Validation - Repeating Table - IP2013

JKnox — Fri, 05 Jun 2015 21:04:31 GMT

It will not allow me to publish. I tried push through the error and the updated form did not publish to my site.

Re: Checkbox Validation - Repeating Table - IP2013

Bre Huston — Fri, 05 Jun 2015 20:36:09 GMT

Are you getting the error while trying to preview this version, or when implementing in your own form?

Re: Checkbox Validation - Repeating Table - IP2013

JKnox — Fri, 05 Jun 2015 18:38:07 GMT

Thanks Bre. However I am receiving an error: "The following expression could not be parsed because of a syntax error or because it uses an undefined namespace prefix or unsupported function: count(xdXDocument:get-DOM()/...."

Re: Checkbox Validation - Repeating Table - IP2013

Bre Huston — Fri, 05 Jun 2015 15:37:48 GMT

Hello JKnox,

Attached is an example that uses a secondary data source for some helper fields to evaluate the repeating table. Sometimes having a 2DS to evaluate the data works much better than validation rules. In this example the check box triggers a set of rules on the /FormLogic/Actions/EvaluateCheckBoxError field, and displays an error in the /FormLogic/Values/ErrorMessage field. If the error message is not blank, then the submit is also blocked, and the same logic exists on the submit button.

Hope that example helps!
Bre