Stunpals on Fri, 06 Oct 2017 18:57:51

I have tried to make a True/False field to check when a value is selected from a dropdown and when that wasn't working I tested  from a button. In both cases instead of it being "checked" (TRUE) the checkbox gets the red dotted validation around it. 

In both cases the action rule is firing correctly and is supposed to set the field to boolean("TRUE"). The strange thing is, I have a similar rule on a different button that changes a different checkbox just fine. If I disable the rule the validation box is not shown as expected confirming the rule I am working on is the one doing this.

Any suggestions on what is happening?

Stunpals - Disclaimer: This posting is provided "AS IS" with no warranties.



Stunpals on Fri, 06 Oct 2017 19:12:43

I tried to change the values to "1" and "0" and test, same result. 

Manu Kaura on Fri, 06 Oct 2017 19:18:33

Try this:

1) Make all fields not required on the whole form.

2) Then I create rules to disable a custom save/submit button until all the required fields are not blank

See if this works...


Enjoy & hope this works...

Happy Sharepointing... Regards SPTECH07

Lakshmanan Sethu on Fri, 06 Oct 2017 19:21:09

Here you go

Stunpals on Fri, 06 Oct 2017 19:43:41

Thanks Maun for the suggestion, I don't have any fields that are set to "required" OR "cannot be blank". I am only using rule validation and I am already using rules on a custom submit button for 3 fields that are used in creating the file name on submit.

I have several other fields and only some are required besides the 3 mentioned above. Others are required only if specific values from other fields are selected. I also want to provide visual validation to the user which ones they are as it is dynamic based on user imput. 

The link you provided is essentially what I am doing and it has been fine until this one checkbox.

Stunpals on Fri, 06 Oct 2017 20:06:02

Lakshmanan thanks for the suggestions both examples with check boxes you provided appear to be functioning in the reverse order in those scenarios.

My checkbox is not for the user to interact with only the rules will check it.

What I am trying to do is I have a field [Comments] which is required if;

  • select other fields have certain values, for example I there are 4 different dropdown fields. If the value of the any of the four dropdowns is "Exceeds" OR "Less Than" I want the user to complete the [Comments] field.

To make that validation rule work directly on the [Comments] field, the validation rule would need to have many OR's in it and there may be other fields that would require a comment. In this scenario I would need 8 OR statements just for these 4 fields.

So my plan was to set the [CommentReq] checkbox field to 'TRUE' if a selected value on the other fields, required a comment so that I could have a more simplified way to validate the [Comments] field.

Stunpals on Fri, 06 Oct 2017 20:12:07

Maybe I'll just write the rule on the [Comments] field with the 8-10 OR statements.

Stunpals on Fri, 06 Oct 2017 20:18:55

Nice just found out you can only create max 5 OR conditions so looks like I'll need to create 4 separate validation rules on the [Comments] field. Unless there is another limitation I will run in to.

croute1 on Fri, 06 Oct 2017 20:51:58

Hi Stunpals- you'll have issues with checkboxes. What I'd suggest is using a text column instead and set that to whatever you want when the dropdown selection is made. Works the same way and you'll avoid problems. 

Stunpals on Fri, 06 Oct 2017 21:18:07

Thanks croute1 I have abandoned the checkbox and am testing the rules directly on the [Comments] field now, if that turns out to be problematic I try the text box solution you are suggesting.

Stunpals on Mon, 23 Oct 2017 18:11:28

Found the cause of the validation (dotted box) error on the checkbox. I was setting the "boolean("TRUE")" in the value field vs opening the Insert Formula with (fx) button and putting it there when I pasted it in.