Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set a column as read-only conditionally on IG

Sgodavar-OracleOct 9 2019 — edited Oct 11 2019

I'm using APEX 18.2. I have two columns(col1 and col2) in an IG and both of them are select lists. For certain col1 values, the requirement is to set the col2 as read only (on change of col1) and for other values in col1, the user should be able to select col2 values(on change of col1) . any ideas are appreciated, thanks for your help.

This post has been answered by Veerendra Patil on Oct 11 2019
Jump to Answer

Comments

Paavo

Hi

perhaps make additional column read_only for toggling read only which is computed based on various values of col1 ? I remember that I had challenges with IG read only settings if there are nulls in the read_only column, so it should be not_null. I am not near my app now, but will check.

rgrds Paavo

Sgodavar-Oracle

I'm not sure how to update that column, if i add another read-only column?. I should be able to select the "col2" and update, when it's not read-only (on change of col1).

Paavo

Hi

How about making app to apex.oracle.com with your requirement ?

rgrds Paavo

Veerendra Patil
Answer

Hi,

Can you use Disable Column col2 on DA

Suppose col1 has 2 values in LOV - 1,2.

On selecting value 1 in col1 - col2 should be disabled,

On selecting value 2 in col1 - col2 should be enabled to select values.

Create a DA on change on col1- as below

1.png

1.png

Create the opposite Action as Enable.

Hope this suits.

Thanks,
Veerendra.

Marked as Answer by Sgodavar-Oracle · Sep 27 2020
1 - 4

Post Details

Added on Oct 9 2019
4 comments
212 views