How to make select list and input text field read only for preventing editing

0
votes

I am developing an oracle APEX application.

I created the form with master details form. How to make select list and input field to read only on tabular form (Add Row Section) when the status value is selected "Closed" or "Cancelled".

I have searched on stackoverflow but I could not find any related question about that. Please give me idea about that ? Thank you..

2
oracleoracle-apex

2 Answers

0
votes

Add a classic report to the page with the same columns. Render the tabular form when the status is not close or cancelled, and render the classic report when it is by using the condition on both regions.

0
votes

Probably half a dozen ways to do this.

Add column in your sql (that isn't displayed to user) that calculates literal value of 'readonly' or null, depending on your status column value. Give it a column alias of 'readonly'

CASE status IN ('Closed','Cancelled') THEN 'readonly' END AS readonly_col

Edit your Status column and add to 'Element CSS Classes' : #READONLY_COL#
(hash tag surrounding your column alias)