Hello.
I am the webmaster for a local squadron of the Air Force Auxiliary, and we are trying to create a registration page for an upcoming event. We have the form working properly, and it saves the information from the user into the database. However, we would like for the system to check the database to see if that person has registered before. Each member of our organization has a Member ID. That ID number is one of the items that the user enters and that is saved into the database. What we'd like is for Chronoforms to check whether or not a row in the DB table contains that ID number already, indicating that the user has registered before. Any help that someone could provide would be greatly appreciated.
Thank you in advanced!
Ethan T Berg
I am the webmaster for a local squadron of the Air Force Auxiliary, and we are trying to create a registration page for an upcoming event. We have the form working properly, and it saves the information from the user into the database. However, we would like for the system to check the database to see if that person has registered before. Each member of our organization has a Member ID. That ID number is one of the items that the user enters and that is saved into the database. What we'd like is for Chronoforms to check whether or not a row in the DB table contains that ID number already, indicating that the user has registered before. Any help that someone could provide would be greatly appreciated.
Thank you in advanced!
Ethan T Berg
Hi Ethan,
Do your members login before they register? If so it might be simpler to check their user ID? Assuming that there is a 1-1 relationship between User ID and Member ID?
Either is possible though.
I'd probably use a first form with just the member ID box and a submit button and use this to check if there is already a registration for this user. If there isn't show the form; if there is show a message to say so. Please see this FAQ for some suggestions for conditional actions.
Bob
Do your members login before they register? If so it might be simpler to check their user ID? Assuming that there is a 1-1 relationship between User ID and Member ID?
Either is possible though.
I'd probably use a first form with just the member ID box and a submit button and use this to check if there is already a registration for this user. If there isn't show the form; if there is show a message to say so. Please see this FAQ for some suggestions for conditional actions.
Bob
This topic is locked and no more replies can be posted.
