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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Protect one column of an interactive grid from user edition allowing DA interaction

PericlesMar 16 2025

Hello

I'm using Apex 24.2 and in an interactive grid I have three columns, one for Seniority, One for hours quantity and one for hour cost.

When the user select from a list of values a seniority, a DA set the assigned cost in the hour cost. I need to prevent the user to edit the column hour cost but allowing the DA to update that field when a seniority is selected.

If I declare the hour cost column as read only, the DA is unable to set the cost.

Another option I tested was to declare two columns, one hidden that store the cost on the table field, and another column as a ghost of the real value that can be edited by the user, but isn't stored on the table, but somehow the value is not stored in the table for the hidden value after setting the column value protected in off. Other issue I have is that when the seniority es selected, the value is shown on the ghost field, but if I try to edit, after query the values the ghost column is not loaded even a process is created to set the values from the real field to it.

Appreciate your comments.

Regards

This post has been answered by Karel Ekema on Mar 17 2025
Jump to Answer

Comments

Post Details

Added on Mar 16 2025
2 comments
78 views