Oracle APEX version 21.3.2
Oracle Database version 19.0.0
I have an simple Form based on a table in APEX. Some of the fields are data entry.
Example: Field 1, Field 2.
Some fields are calculated on the fly and then upon saving the data in the form, that calculated field gets saved in the database, thus upon re-querying that record, the field is not “re-calculated” just simply read from the database.
Example: Field 3
So far easy to do. The question is….how do I make this calculated “field” appear “read-only”? Meaning the user has NO input whatsoever in the field.
I have Dynamic Actions on Field 1 and Field 2 (when change) and the True action is “Execute Server Side Code” that calculates the Field 3 based on a formula ( (FIeld 2 - Field 1) / Field 1) = Field 3. When a change happens to either 1 or 2, immediately 3 gets updated. So far so good. Works as expected.
But as soon as I make hard code making field 3 “read only” or a field type of “Display Only” that's when I get errors in trying to save the data. I tried to enable/disable but that happens before saving.
Any suggestions/thoughts?
Thanks