Clever Geek Handbook

Oracle Apex 4.2.4 Show only fields not stored in database

I am using a dynamic action to auto-populate data in fields based on the person ID that is pulled from another table (which pulls the division of person, employee #, etc.). This works great if I leave the auto-filled fields, but I only want those fields to appear so that the person entering the data cannot edit it. This is the whole reason for using dynamic actions. When I set the fields to display only, the data is never saved in the table, so the fields are empty when I run the report on a record. Is there a way to get these fields to populate the database and still not be edited. Do I need to start another process "behind the scenes" in order to fill them in, for example with the "on submit" process?

+3


source to share


3 answers


Use the Text field and then set the "HTML Form Element Attributes " with readonly = "readonly"; ...



+5


source


Create an additional hidden item and save it instead of a read-only item. Assign your dynamic actions to change values ​​for both read-only and hidden items.



0


source


You can create a display / read element only for updating by setting the display as the value of the text box and set the type read-only element Always .

enter image description here

0


source






More articles:


All Articles