CODEWITHSUNDEEP
oracle-databaseoracle-apex
user3036268
user3036268

Reputation: 13

PL/SQL dynamic actions

having another problem with some PL/SQL code.

My booking form currently has a dynamic action applied to the discount field. Radio buttons set at Yes and No. When Yes is clicked it enables the fields Vouchercode and Discountamount.

What I would like to do is set these fields to NOT NULL when discount = yes. BUT be null if discount = no

Thanks

Upvotes: 1

Views: 445

Answers (1)

Jeffrey Kemp
Jeffrey Kemp

Reputation: 60312

It sounds like you want to change the Required validation on the Vouchercode and Discountamount fields depending on whether discount is 'Yes'.

To do this, you change the validation code - you don't need a dynamic action.

e.g. instead of checking if Vouchercode IS NOT NULL, change the validation to check Vouchercode IS NOT NULL OR discount = 'Yes'.

Upvotes: 1

Related Questions