Skip to main content

Hi,

I am designing a form to request people to select the default payment method first, and then request for the bank account detail info.  I would like to have the logic as if the person chosen Paypal as the default Payment method, then everything in the panel (red area) is an optional for this person, however, if *Bank Transfer* was ticked, then everything in the panel is required.

 

I tried to set the rule, but I found I can only hide or disable the panel. Does anyone know other better way do make this happen? Thanks!

Zoe

178858_pastedImage_1.png

Hi Zoe,

You need to add validation on all 5 fields based on Payment Method.

Ex: For Bank Name: If Payment Method is Bank Transfer and Bank Name is empty, then  Bank Name is mandatory

Regards,

Christophe


Thanks Cristophe!

could you teach which formula I should use?

I use and(equals(Paymentmethod,"Paypal"),equals(Paypal Account)," ")) for setting the mandatory validation if the user submitted Paypal as the payment method, but it doesn't work....

178860_pastedImage_0.png


Zoe,

equals(Paypal Account)," ")) should be equals(Paypal Account),"")) without the space I guess

Regards,

Christophe


I made the change and(equals(Paymentmethod,"Paypal"),equals(Paypal Account,""))

but still not working....

in the following test, Paypal account should be detected and returns error message, but it got passed....  

178868_pastedImage_2.png


Zoe,

It seems correct.

Try to test with Paypal Account only, then with Paymentmethod only to narrow your issue.

Regards,

Christophe


Christophe, thanks for your support!

I tried and it doesn't work....If I filled up other things correctly, and picked Paypal as the payment method but left the Paypal account empty, it allows me to submit without returning any error message....


Zoe

Can you paste a screen shot of your form in design mode?


here you go happy.png

178869_pastedImage_1.png


Zoe,

Please check the setting of your Payment Method control

The Choices attributes must be Bank Transfer,Paypal without a space before Paypal


I double checked it again, confirmed there is no space before and after....confused.png

178872_pastedImage_2.png


Zoe,

Try something different

PaymentMethod == "Paypal" && PaypalAccount == ""


Hi Zoe,

just for confirmation, the PaymentMethod and PaypalAccount reference are inserted from the Named Controls tabs and not from the Item Properties one?

Giacomo


Yes, I selected them from the name controls

178877_pastedImage_0.png


Christophe, I am not sure how to convert the formula you shared above into the real formula, would you mind to type the full version for me? Sorry I am very new to this...blush.png

Thanks,

Zoe


Zoe,

I must admit that this is a formula written in O365.

Are you not able to written the same formula by picking the control and the operators?

But you can also manually write the operators


it doesn't work, is there anything I did wrong?

178919_pastedImage_0.png


No, I am afraid


ok...I hope the miracle will happen


instead of equals(PaypalAccount,"") try equals(self,"")


I tried {self} in two different formulas, but it doesn't work....

Payment Method=="Paypal" && {Self} ==""

and(equals(Payment Method,"Paypal"),equals({Self},""))

possible I set something wrong? I just added another cell named *edition Record*, the rule setting works for formatting, but doesn't work for validation again...

I use the rule to control this Edition Record only appear when is edit mode, which works, and I have another rule to set the validation to force if the cell is empty, it should trigger the error message to ask the person to provide edition info, and this doesn't work....

179021_pastedImage_4.png


Actually, I'm having issues with form validation rules since the latest 2010 nintex upgrade. Mine are mainly failing on choice (drop down) fields. Have you had an upgrade lately?


Hi Joanne,

my version is Nintex Forms 2013

Version: 2.4.1.0


it doesn't work for me again....., in fact, not just this one, all other validation rules I set not working. cry.png

179059_pastedImage_4.png


Hi Zoe,

If all your validation rules are not working, could you check your form with the browser developer tools open to see if there is any JavaScript error?this may cause your issue..

Giacomo

Il 04/mar/2016 07:46 zoe <community@nintex.com> ha scritto:

Nintex Community <https://community.nintex.com/?et=watches.email.thread>

panel validation depends on the option in another filed

reply from Zoe Yeh<https://community.nintex.com/people/zoe?et=watches.email.thread> in Getting Started - View the full discussion<https://community.nintex.com/message/34063?et=watches.email.thread#comment-34063>


Hi Jan,

I reenter the formula as what you shared with me, still not working...., but thanks for the notice on the format, I fixed the overlapped parts, in case it will later affect on other functions. happy.png


Reply