Idea Summary
In Oracle APEX Interactive Grid, the Change event for a dynamic action tied to a checkbox column should be triggered without requiring the user to enter Edit Mode. Currently, users are able to check or uncheck checkboxes and save the grid without explicitly switching to Edit Mode, however, the associated dynamic actions do not execute unless Edit Mode is active. As an alternative, users could be restricted from modifying checkbox values unless Edit Mode has been activated. Aligning the dynamic action behavior with the actual user interaction would improve consistency and usability.
Use Case
In an Interactive Grid used for managing employee data, one of the columns is a checkbox labeled "Is Contractor". When a user checks this box, a dynamic action is intended to show or hide additional columns / disable some columns such as "Contract End Date" and "Contractor Agency", making the grid more intuitive and tailored based on input.
Preferred Solution (Optional)
The Change event of the dynamic action associated with a checkbox column in the Interactive Grid should be triggered when the user checks or unchecks the checkbox, without requiring entry into Edit Mode. Or the users could be restricted from modifying checkbox values unless Edit Mode has been activated.