Search code examples
oracleoracle-apexsurvey

How to create multiple forms in one page with multiple submit buttons in APEX?

I am creating a survey application in oracle apex that has multiple tabs for survey in one page. However, it is not allowing me to submit one tab at a time and is throwing errors like-

1 error has occurred Column QUES9 not found in table CUST_FB_RU2C

I think its trying to submit all forms at once. What should be done?

Solution

  • The simplest option is to submit only once, at the end of the survey.

    Another option (if you want to allow partial submits) is to create one page per group of questions in the survey and submit page-by-page.

    Or - if it has to be one page - then you'll have to create your own submitting logic and write your own processes which will perform database insert action, inserting only items which are relevant to each of those submit buttons.