4 Replies Latest reply on Oct 11, 2019 9:54 AM by Veerendra Patil

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

Sgodavar-Oracle Oct 10, 2019 2:01 AM

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.

1. Re: How to set a column as read-only conditionally on IG

Paavo Oct 10, 2019 7:29 AM (in response to Sgodavar-Oracle)

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
Like Show 0 Likes(0)

Actions
2. Re: How to set a column as read-only conditionally on IG

Sgodavar-Oracle Oct 10, 2019 4:09 PM (in response to Paavo)

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).
Like Show 0 Likes(0)

Actions
3. Re: How to set a column as read-only conditionally on IG

Paavo Oct 10, 2019 9:28 PM (in response to Sgodavar-Oracle)

Hi

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

rgrds Paavo
1 person found this helpful
Like Show 1 Likes(1)

Actions
4. Re: How to set a column as read-only conditionally on IG

Veerendra Patil Oct 11, 2019 9:54 AM (in response to Sgodavar-Oracle)

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

Create the opposite Action as Enable.

Hope this suits.

Thanks,
Veerendra.
1 person found this helpful
Like Show 1 Likes(1)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.