Good afternoon,
We have been using FTs for a few years to handle contest registrations. It has allowed us to get the benefits of a DB without the need to create our own PHP code. ... But, now I have a need to link some of these DBs together or at least share some of the data.
Here is the problem/task:
1) We have an existing DB (DB#1) containing contest entrants (Fname, Mname, Lname, ..., email,etc.).
2) We now have a secondary contest for the event requiring a new/additional entry form with fewer fields and an additional fee (DB#2).
3) Anyone who has already paid for entry into the main contest can enter the secondary contest for free, but they need to actually enter. We do not automatically enter them (we need an accurate headcount for planning purposes).
4) My plan
1) have the user enter only their email address (double entry) one the first page of the entry form. Once submitted search for a matching entry in the email field of DB#1.
2) If a match is found: Copy the necessary fields from DB#1 to a "new" submission in DB#2; redirect to a confirmation page "Since you are already registered for contest 1, we have entered you in contest 2 for free! ...."
3)If no match is found: redirect to standard entry process and submission (paypal first, form entry, confirmation /thank you page...)
Can this be done from within FormTools? Or, will I need to create my own PHP code? Can this be done using the API tools? Any and all feedback appreciated.
Sorry for the lengthy explanation.
TIA
We have been using FTs for a few years to handle contest registrations. It has allowed us to get the benefits of a DB without the need to create our own PHP code. ... But, now I have a need to link some of these DBs together or at least share some of the data.
Here is the problem/task:
1) We have an existing DB (DB#1) containing contest entrants (Fname, Mname, Lname, ..., email,etc.).
2) We now have a secondary contest for the event requiring a new/additional entry form with fewer fields and an additional fee (DB#2).
3) Anyone who has already paid for entry into the main contest can enter the secondary contest for free, but they need to actually enter. We do not automatically enter them (we need an accurate headcount for planning purposes).
4) My plan
1) have the user enter only their email address (double entry) one the first page of the entry form. Once submitted search for a matching entry in the email field of DB#1.
2) If a match is found: Copy the necessary fields from DB#1 to a "new" submission in DB#2; redirect to a confirmation page "Since you are already registered for contest 1, we have entered you in contest 2 for free! ...."
3)If no match is found: redirect to standard entry process and submission (paypal first, form entry, confirmation /thank you page...)
Can this be done from within FormTools? Or, will I need to create my own PHP code? Can this be done using the API tools? Any and all feedback appreciated.
Sorry for the lengthy explanation.
TIA