Hello chaps,

I want to know if a particular thing can be done at all in Dynamic Forms before I start spending too much time trying to figure out how to do it.

The scenario is as follows:

1. People have paper tickets to an event
2. Each ticket has a unique number on it
3. After the event is over, people will be invited to come to a website and enter their ticket number and email/phone into a form to go into a draw.

It's easy enough to create a form to gather all the details, but the bit I need to figure out is how to check that each number is only entered once.

I also need to make it less easy for people to make up numbers they don't have and entering them as their own - thus removing the ability for the legitimate ticket-holder to enter their own details.

The ultimate validation check will be that the winner will have to produce the actual ticket or they won't get the prize, so the online system doesn't have to be 100% fail-safe. It just has to produce a list of unique numbers and addresses for picking a winner from.

Is there a function in Dynamic forms that will provide this sort of check against data already entered?

I'm wondering if I really should in fact be using some sort of email verification to make this work better. Perhaps I should be using DNN account registration with verification and a custom field for the code - that would at least stop people from making up numbers and fake emails just to clog the system up. But I'm also not all that keen on having thousands of user accounts created just for the purpose of the draw.

Any ideas or advice on this is much appreciated
Rob

Yes, I believe this is possible with DF SQL Validation under Module Configuration / Validation Configuration. You can use a store procedure to query a database table that has all the numbers and return a value if it's valid or not. If not, the form won't submit. -- David