- adojacobAsked 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.
- CarinaAnswered on October 23, 2015 at 10:43 AM
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.