panel validation depends on the option in another filed

[zoe]

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

[christopheraucq · Accepted solution]

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

[zoe]

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....

[christopheraucq]

Zoe,

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

Regards,

Christophe

[zoe]

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....  

[christopheraucq]

Zoe,

It seems correct.

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

Regards,

Christophe

[zoe]

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....

[christopheraucq]

Zoe

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

[zoe]

here you go

[christopheraucq]

Zoe,

Please check the setting of your Payment Method control

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