Oracle Apex 4.2.4 Display only fields not saved to database
oracle-apex
Solution
Use Text field and then set the "HTML Form Element Attributes" with readonly="readonly";.
Problem
I am using a dynamic action to auto fill data into fields based on the ID of a person that is being pulled from another table (which pulls the person's dept, employee#, etc). This works fine if I leave the auto populated fields editable, but I want these fields to be 'display only' so that the person entering the data cannot edit it. That's the whole reason for using dynamic action. When I set the fields to 'display only', the data never gets saved to the table so the fields are blank when I run a report on the record. Is there a way to get these fields to populate the database and still not be editable. Do I need to run another process 'behind the scenes' to get them populated, like with an 'on submit' process?