Emails sent, form entered in dB, even though transaction cancelled

[filch]

Hey Dave,

How's it going?

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!).

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