Browser Forms

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Fri, 20 Apr 2018 19:44:56 GMT

Oh how funny, I was just typing the same suggestion up! Glad things are working now.

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Fri, 20 Apr 2018 19:43:05 GMT

I believe I figured out the MS box issue. I had to change the 2nd condition to: All occurrences of Value are Blank. Now the box re-enables once I check a department.

Hilary thank so much for your time and sticking with me to the end. I so appreciate it!

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Fri, 20 Apr 2018 19:01:27 GMT

That Xpath code did work! Thank you! Is there a guide as to how you put that code together?

I applied similar code to the Additional Classes dropdown and it worked perfectly.

I applied similar code to the MS Box. It did not work. Is this another caveat of MS boxes?

As a test I used just 2 conditions to test:

The expression: starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/dfs:dataFields/my:SharePointListItem_RW/my:Class], "CADLP Cadence Template Builder")

The expression: dfs:dataFields/my:SharePointListItem_RW/my:Epic_x0020_Depts_x0020_HC/Value = ""

When I select a CADLP Cadence Template Builder class from the Class dropdown box, it does disable the Submit button, but once I check a value in the Epic Depts MS Box, it does NOT become enabled, and it should. So I presume I may need to reference a null value in the MS Box some other way?

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Fri, 20 Apr 2018 15:45:43 GMT

The current function is contextual - I think you need something like this on your submit button: starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/dfs:dataFields/my:SharePointListItem_RW/my:Class], "Reporting 100")

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Fri, 20 Apr 2018 15:34:41 GMT

Hmmm. That's odd that it works for you and not on my form.

Yes disabling the Submit button would work as well. I already tried doing that without success though.

I used the following Rule:

Condition:
not(starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/my:Class], "Reporting 100")) AND
not(starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/my:Additional_x0020_Classes], "Reporting 100")) AND
Reporting Security Access is Blank

Rule Type: Formatting. Disable this control is checked.

The Submit button never disables for me. I've attached the template again with the rule above. I would love to get this all wrapped up today as I am out of the office all next week. Any assistance is greatly appreciated!

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Fri, 20 Apr 2018 14:56:37 GMT

I can't reproduce this - I set up a similar scenario on my SharePoint 2013 site, with a choice column that I made required if the lookup's ID = an ID where the title started with a certain string, so much like yours for the Reporting Security Access - and my validation works as anticipated. Perhaps since you have a submit request button on your form, you could just disable that instead, if the Reporting Security Access field isn't populated when it is needed?

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Fri, 20 Apr 2018 14:32:54 GMT

No worries. I have attached my latest iteration of the form. All is well except for making the Epic Depts MS box required, which I guess is not possible through a normal Validation rule. Also the Validation for the Reporting Security Access drop down box is not working either. Everything else is working and good to go. I have attached the template for your review if its helpful. Thank you again!

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Fri, 20 Apr 2018 00:07:36 GMT

Hey, Lou, I'm sorry, but I didn't get a chance to try this today. I will in the morning. :)

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Thu, 19 Apr 2018 18:44:38 GMT

I'm going to run a test on a list form later today & see if this reproduces for me at all. Just in case the issue is with the custom validation - I'll let you know what I learn

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Thu, 19 Apr 2018 18:40:16 GMT

Field: Purpose For Reporting Class

Rule which works properly:

Rule Type Validation:
Value - "Reporting (eParc)"
Purpose For Reporting Class is Blank

Field: Reporting Security Access

Rule which did NOT work properly and has since been removed:

Rule Type Validation:
The expression: starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/../my:Class], "Reporting 100")
Reporting Security Access is Blank

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Thu, 19 Apr 2018 18:32:57 GMT

Which field?

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Thu, 19 Apr 2018 18:27:43 GMT

Yes.

Re: Hidden section not displaying when using rule criteria

Hilary Stoupa — Thu, 19 Apr 2018 18:21:19 GMT

So on the field where this is working, is this also a validation rule?

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Thu, 19 Apr 2018 17:57:06 GMT

Hi Hilary!

I thought this was good to go. I pushed this to live last night was not able to complete the form as it said a required field was not filled out. Reporting Access Required. As you know that section is conditional and only appears when the user selects a Reporting 100 class. However when they do not select a Reporting 100 class, it is still wanting that field filled in, even though it's not showing. I had to remove the validation rule. So now it appears when they Select Reporting 100 but its not required. It needs to be required when Reporting 100 is selected, other wise it should be hidden and not required to submit the form.

Here's the validation rule I removed:

The expressions: starts-with(xdXDocument:GetDOM("ClassInfoForEnrollementForm")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:Class[../d:ID = current()/../my:Class], "Reporting 100")
starts-with(../my:Class, "Reporting 100")
Reporting Security Access: is blank

Any idea why this is happening? I was using the same type of logic that's being used on another field and that one works as expected. I've attached my current template again with the rue removed.

Thank you so so much for your help.

Re: Hidden section not displaying when using rule criteria

Lou Gonzalez — Fri, 13 Apr 2018 12:05:10 GMT

Thanks again Hilary! You've been an invaluable help to me. Strangely, the form template that I was using yesterday that didn't show the required asterisk, now shows today! I'm not sure why all of sudden it would work today but not work yesterday. I'm using the exact same form. Either way the asterisk is now showing as expected and I didn't change anything (except rebooting my PC this morning). Nonetheless I am good to go. I hope our conversation helps someone else here.

I do have another question but I will start a new thread if I can't find the solution on the forum.

Thank you and have a great day!