I have an Interactive Grid with the following editable columns:
My requirement is to enforce a sequential data entry process.
The user should not be able to move to or edit the next column until the previous required column has been entered.
For example:
- If Quantity is empty, the user should not be able to click into or edit the Rate column.
- if he try to enter value in rate column an error will be display ‘Enter Quantity first’
- If Rate is empty, the user should not be able to click into or edit the GST column.
In other words, the user must complete the fields in this order:
Quantity → Rate → GST
Is there a supported way to implement this behavior in an Oracle APEX Interactive Grid using JavaScript or the Interactive Grid API? Or any other way.