+- 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: Emails sent, form entered in dB, even though transaction cancelled (/showthread.php?tid=900)
Emails sent, form entered in dB, even though transaction cancelled - filch - Oct 27th, 2010
Ben,
Have just completed a Paypal form and am seeing some oddities. First, the form has a drop down menu that has three options. However, even though I may choose option two or three in the form, in the database, it is always the first option that is selected. However, the emails that are sent out are correct??
Second, even though a transaction may be canceled, it still gets entered into the database. This should not happen ... should it?
Dave
RE: Emails sent, form entered in dB, even though transaction cancelled - Ben - Oct 28th, 2010
Hey Dave,
How's it going?
Quote:First, the form has a drop down menu that has three options. However, even though I may choose option two or three in the form, in the database, it is always the first option that is selected
Hmm... sounds like maybe the values in the dropdown don't make the values in the Field Option Group for the field... Maybe double check that first (let me know if you need some pointers on this - it's not the most intuitive thing in the world!).
Quote:Second, even though a transaction may be canceled, it still gets entered into the database. This should not happen ... should it?
That depends. When using the API, all submissions will get added to the database, but only those that get marked as "finalized" will actually appear in the Form Tools user interface. Do you see them all in the UI? If so, look over the PHP for your form pages and check that you're not passing the: "finalize" => true parameter to the ft_api_process_form() function anywhere.
For PayPal forms, the only time a submission is finalized is in the ipn.php file.
Hope this helps a bit -
Ben
RE: Emails sent, form entered in dB, even though transaction cancelled - filch - Oct 28th, 2010
(Oct 28th, 2010, 5:29 PM)Ben Wrote: Hey Dave,
How's it going?
Quote:First, the form has a drop down menu that has three options. However, even though I may choose option two or three in the form, in the database, it is always the first option that is selected
Hmm... sounds like maybe the values in the dropdown don't make the values in the Field Option Group for the field... Maybe double check that first (let me know if you need some pointers on this - it's not the most intuitive thing in the world!).
Quote:Second, even though a transaction may be canceled, it still gets entered into the database. This should not happen ... should it?
That depends. When using the API, all submissions will get added to the database, but only those that get marked as "finalized" will actually appear in the Form Tools user interface. Do you see them all in the UI? If so, look over the PHP for your form pages and check that you're not passing the: "finalize" => true parameter to the ft_api_process_form() function anywhere.
For PayPal forms, the only time a submission is finalized is in the ipn.php file.
Hope this helps a bit -
Ben
Humm .. I think that is it as I have the following in my form at the top:
Code:
<?php
require_once("/web/support.zuka.net/docs/formtools/global/api/api.php");
if($_POST['howpay'] == "invoice"){
$fields = ft_api_init_form_page(11);
$params = array(
"submit_button" => "submit",
"next_page" => "inv-thanks.php",
"form_data" => $_POST,
"file_data" => $_FILES,
"finalize" => true
);
ft_api_process_form($params);
} else {
//echo "<input name=\"item_name\" type=\"hidden\" value=\"" . $_POST['appType'] . "\" />";
$item_name = $_POST['appType'];
if($item_name == "institution") {
$amount = "$349.00";
} elseif($item_name == "individual") {
$amount = "$37.45";
} else {
$amount = "$50.00";
}
$fields = ft_api_init_form_page(11);
$params = array(
"submit_button" => "submit",
"next_page" => "paypal_submit.php",
"form_data" => $_POST,
"file_data" => $_FILES,
"finalize" => true
);
ft_api_process_form($params);
}
?>So you are saying, because this is a Paypal form, the " "finalize" => true" should be deleted ... correct? Does it say this anywhere in the tutorial and I am just blind and did not see it?
As far as the other item, are you referring to view options/groups?
Dave