Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set default value to a hidden column when adding a new row to tabular form?

DannyS-OracleSep 6 2016 — edited Sep 7 2016

Hi guys,

I tried to create a tabular form of a table, where I can do Insert, Update, and Delete operation of a table's data. Let's say the table should list students' data like classroom_number, name, email, etc. This tabular form page will be accessed from another page, where I can choose a classroom number. So when the classroom number clicked, it will open the tabular form, which shows only students from the chosen classroom number. It also set the classroom number in a hidden item at the tabular form page (e.g. P2_CLASS_NUMBER).

Since the classroom number is supposed to be the same and does not need to be edited, I set the Class_Number column as hidden-type column. But the problem comes when I clicked the "Add Row" button of the generated tabular form, the Class_Number of course will be null, and to make it worse, a hidden-type column does not allow me to set the "Default Value" attribute from the Page Designer.

Screen Shot 2016-09-06 at 7.21.23 PM.png

(There is also a weird "/> character generated by Apex at the Phone column )

How can I automatically set the Class_Number column value when clicking the Add Row button?

P.S. I am using Apex v5.0.4

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 5 2016
Added on Sep 6 2016
5 comments
1,632 views