JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Unqiue Code ValidationAsked by Adam Hicks on March 11, 2015 at 10:14 PM
Hi guys, looking into your site and want to see is jotform is able to do it. The forms I want to create are for Competitions.
When people buy a product they receive a card with a unique code and get lead to a form to enter. On that form there will be a field called Unique Code.
They will then enter the Unique code they received on the card.
However what I need is for the form to Validate a database of over
30,000 codes. Is there a way that this can be managed on your creator?
From having a look I see that you can do this sort of thing via conditions - however I'm not sure how to implement it.
Unfortunately, I believe JotForm is not designed to have forms to handle those kind of list. If you add it to the "Conditions" you'll actually need to type or enter 30,000 codes in the setup, that would also cause the form to freeze and crash in the browser.
For this kind of cases, this is what I could recommend.
1. Create a form and redirect it to a PHP script to return a validation or verification for the form. Here's a guide on how to pass POST Data to PHP: http://www.jotform.com/help/213-Send-POST-Data-From-JotForm-Using-PHP-in-Custom-Thank-You-Page.
I hope this helps.
I think you should hire a PHP programmer in order to accomplish what you are looking for, to best optimize the database queries and PHP conditional sentences for the 30,000 codes that will be hosted in your database.