Menu

ApEx 4.0 : Tabular Form Validations

An other nice feature of ApEx 4.0 will be the option to create tabular form validations. This will give tabular forms the only thing it missed so far, an easy way to validate the data before you try to save it.

In the previous editions you could write your own validation for a tabular form but you had to take care of the session state of the data you filled in, otherwise the date you changed would be lost if a validation was triggered.

Hi, Whilst this works well for first round submissions, it doesn’t seem to work should the user click on submit again without fixing the errors identified from the first submission.
I have searched high and low for a solution, but can’t seem to find one… Any ideas?

This tabular form was generated via the wizard, and hence the tabular form validations were created by the Wizard also.
If you add 1, 2, or 3 new rows, and only populate the Qty field for each of these new rows… And then click the submit button, the tabular form validation works as expected. It identifies that you have not populated the other fields on the new row(s).
However, if you click submit again without changing anying on the form (ie. leaving the highlighted required fields blank) the page submits and the MRU process attempts to run. But because of the blank fields it errors out

I have a question on Apex 4 tabular forms. I have a form with a multi-select field on top of my form with a add button and a tabular form below it. What I need to ask is:
1. Is it possible in apex 4.x to multi-select from my select list and based on my selected items when I press the ADD button on the selectlist dynamically trigger addRow() tabularform button in Apex to pre-populate the selected values from my select list?

I have done this using pl/sql using htp.p() I created my own javascript and ajax calls to do this, its able to pre-populate the values before they can be saved into the database.

is it possible with apex and how, my measure problem is that I don’t know when and how the addRow() is being used i tried browsing most documentations and blogs but I dont find a solution.

I’m trying to build a tabular form with a total column, which is the result of summing two other ones. By using JavaScript I could achieve that for already existed records, since the ‘ids’ exist.
How could I sum these two columns for a new record?