cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Nintex Newbie

isNullorEmply() field not working for a hidden panel

Jump to solution

Hi, 

 

I have a hidden panel in my Nintex form that has a required field. When a user goes to submit the form, the form doesn't submit because the it returns with an error message "Fill in required field", however it is hidden to the user.

 

Is there a formula I can apply to the hidden panel field to only be required when in edit mode? 

Capture.PNG

 

Any help appreciated.

 

 

Labels: (1)
Tags (3)
0 Kudos
Reply
9 Replies
Highlighted
Nintex Employee
Nintex Employee

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

Hi,
Basically you need to apply a similar rule to the validation as you do for hiding the panel.
Example:
If you hide a panel when a choice control is yes : Choice == "Yes"
You have a control in the panel that does not need validation when Choice == "Yes"

Validation would be and(isNullorEmpty({Self}),equals(Choice,"No"))

If choice is No the panel will not be hidden and therefore the control will need validation.

Sample Classic form attached to demonstrate this functionality.

View solution in original post

Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

I applied what you've told me and it worked! 

 

Thank you!

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

Hi,

I tried to use this in Responsive form and didn't work. 

does it work diffrent in responsive form than Classic form.

 

Thank you for your help.

 

0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

@rkbud This works the same in classic or responsive forms.

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution
OPTION&&isNullOrEmpty(Hidden field) . this formula works for me.

But i have another issues while validating hidden field. Hidden field is shown when there is multiple drop down values. lets suppose, we have dropdown field with A,B,C,D,E values. field is hidden when D,E is selected. I am using Option="A"&&Option="B"&&Option="C"&&isNullOrEmpty(HiddenField)
0 Kudos
Reply
Highlighted
Nintex Employee
Nintex Employee

Re: isNullorEmply() field not working for a hidden panel

Jump to solution
This is expected behavior. The only way controls can be validated when hidden is if they are connected to a SharePoint column and that SharePoint column is set as required.
0 Kudos
Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

In my case, Hidden field is connected to sharepoint column and non required column. 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

@SimonMuntz Sorry if i wasn't clear on my previous post. I am trying to validate hidden date field when that field is shown on the form. I have two column i.e. Column A with multiple dropdown(values A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P) and  Column B (date field). Column B  field is shown when dropdown on Column A are A,B,C,D,E,F,G,H,I only. 

I have formula to hide the field as Column A!="A"&&Column A!="B"&&Column A!="C"&& Column A!="D"&&Column A!="E"&&Column A!="F"&&Column A!="G" && Column A!="H"&&Column A!="I".

I get validation to work when chosing only one value ie. equals(Column A, "A")&&isNullOrEmpty({Self}). The issues is if i tried to add other values in validation. It won't work. I am trying to minimize writing other eight rules for the same field. 

 

Thank you in advance for your help.

 

0 Kudos
Reply
Highlighted
Nintex Newbie

Re: isNullorEmply() field not working for a hidden panel

Jump to solution

I used 'or' expression and got it to work.

or(equals(Column A, "A"),or(equals(Column A, "A")))&&isNullOrEmpty({Self})

 

 

0 Kudos
Reply