Forum Stats

  • 3,734,761 Users
  • 2,247,037 Discussions
  • 7,857,483 Comments

Discussions

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

Sgodavar-Oracle
Sgodavar-Oracle Member Posts: 1,011 Employee
edited Oct 11, 2019 2:12PM in APEX Discussions

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.

Sgodavar-Oracle

Best Answer

  • Veerendra Patil
    Veerendra Patil Member Posts: 537 Gold Badge
    edited Oct 11, 2019 5:54AM Accepted 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.

    Sgodavar-OracleSgodavar-Oracle

Answers

  • Paavo
    Paavo Member Posts: 627 Silver Badge
    edited Oct 10, 2019 3:29AM

    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
    Sgodavar-Oracle Member Posts: 1,011 Employee
    edited Oct 10, 2019 12:09PM

    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
    Paavo Member Posts: 627 Silver Badge
    edited Oct 10, 2019 5:28PM

    Hi

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

    rgrds Paavo

    Sgodavar-OracleSgodavar-Oracle
  • Veerendra Patil
    Veerendra Patil Member Posts: 537 Gold Badge
    edited Oct 11, 2019 5:54AM Accepted 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.

    Sgodavar-OracleSgodavar-Oracle
Sign In or Register to comment.