What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can I pass values to another form?Asked by adojacob on October 23, 2015 at 04:47 AM
I have one form (Form 1, linked below), which (among others) results in values for the following: FirstName, Unique Code (assigned to each submission), ProductsPurchasedCode (refers to which product was bought, 2-9).
What I would like to do is make a second form (Form 2) which has one field, for the user to enter in their Unique Code (possibly at another time and on another computer). After the code is entered, I want to check against a database of Form 1 submissions, confirm the code entered matches an entry (or redirect to error page), then be able to access the values for FirstName and ProductsPurchasedCode related to the entered Unique Code.
Some example values could be:
So, the user would enter 'NAME123456' into Form 2, the form would look up the FirstName (NAME) and ProductsPurchasedCode (5). ProductsPurchasedCode would then tell the form to redirect to the appropriate page (page 5), and NAME would be displayed (although the name part is not essential).
I have attached a rough diagram of how this would work. Is this possible? I currently have Form 1 set up to store submissions in a Google spreadsheet. I'm not skilled with PHP or MySQL (or any coding), but am willing to learn if necessary.
Thanks very much, please let me know if you need any more information.
There is this option to save forms to continue later, that perhaps might meet your needs and it's much simpler:
There is this option to also populate the 2nd form with values from the first. The user would then get an edit link that would allow him to get back to the form later and edit the submission.
Let us know if this is a solution for you.