The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.31 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.31 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.31 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
using one Formtools DB to auto-fill corresponding fields in a new FormTools DB fields - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: using one Formtools DB to auto-fill corresponding fields in a new FormTools DB fields (/showthread.php?tid=2972)



using one Formtools DB to auto-fill corresponding fields in a new FormTools DB fields - FTinfo - Mar 30th, 2014

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


RE: using one Formtools DB to auto-fill corresponding fields in a new FormTools DB fields - kaamil20 - Mar 31st, 2014

It is a great idea of you that you are using one form tools. Keep it continue.