- ukffAsked on September 01, 2013 at 12:23 PM
I have a form that has a dropdown with 3 options (A,B, and C) on the landing page and each option directs the user to a different pagebreak (using Conditions statement).
I have found that it is possible for a user to for example select option A and fill most of the fields on the option A page and then click "Back" to the landing page and choose option B and fill some fields in the option B page and then submit the form. The consequences are that I get some data on the spreadsheet that is not wanted and the Conditions logic becomes very difficult to manage.
Also, there are cases where an answer to a question means that I need to direct the user from option B page to option A page. In this case I would like all the data that is entered in that page to be cleared when the user clicks "Next" and is directed to option A page (using Conditions).
The main reason I designed all the required functionality into one form (rather than 3 separate forms), is because I wanted to export ALL the data to ONE Google spreadsheet. I don't know if jotform allows you to export data to 3 different worksheets in the same Google spreadsheet?
Your guidance is appreciated.
- JotForm SupportjonathanAnswered on September 01, 2013 at 01:45 PM
It is not possible to use the page break field to do the refresh/clear/reset form function in the form.
Only the "Clear" or "Reset" button have this command.
" I have found that it is possible for a user to for example select option A and fill most of the fields on the option A page and then click "Back" to the landing page and choose option B and fill some fields in the option B page and then submit the form. "
Yes. This is true.
The condition logic on the form will not be able to "clear" or "reset" the field values. The condition can only show/hide or jump pages on the form.
But to prevent the form user from advancing on the form -- when conditions are not correctly satisfied, is to prevent the submit button from being used
skip the page back to the same page when Next button is used.
I could see that you did this already on your form http://www.jotform.com/32225919072857 . This form will always go back to 1st page if the "Club" is not listed.
You might as well add a final condition -- that disable the submit button if there are still mismatch in the answers (or they are not according to condition). Just add an annotation using the Free Text(HTML) field telling the form user that there are incorrect choices.
Hope this help. Inform us if yo need further assistance.