[Plugin: Contact Form 7 to Database Extension] add info after form submited

  • I am using Word Press 3.0.5
    I installed Fast Secure Contact Form v2.9.8.3
    and Contact Form to DB Extension v1.6.5

    I have been able to create a form, and have it generate a table in Contact Form to DB Extension to display the information submitted. Works like a charm!

    I am looking for help to be able to add information to the record created. In a nutshell, I would like to be able to add a column where I could enter some comments to know which form submnission has been followed up, what happened, etc.

    Guy

Viewing 11 replies - 1 through 11 (of 11 total)

  • This setting on the form edit page will add a column when the form is posted.
    Data export key value pairs to add: set it to
    followup=no

    Then you have the column you want. Hopefully Contact Form 7 to Database Extension lets you edit?

    Mike

    Contact Form to DB Extension does not currently allow you to edit the data in the tables. But that is on the “to-do” list.

    Do you have an estimated time frame for the ability to edit data?

    Fantastic plugin btw.

    Cheers,
    Lee

    Not at this time…

    What I did is:(using PHP code)

    1. Use the “submit_time” field to get your record.
    2. Show all fields’ value in your form in html page
    3. When click Submit,

    ———————————-
    if no upload new file
    ———————————-
    use MySQL to update this field

    $query = "UPDATE wp_CF7DBPlugin_SUBMITS SET field_value = '". $researchTopic	 ."' WHERE form_name = 'your_form_name' AND submit_time = ". $submit_time ." AND field_name = 'researchTopic'";

$result = mysql_query($query);

    ——————————
    if upload new file
    ——————————
    insert a new record, remove the old one

    [Code moderated as per the Forum Rules. Please use the pastebin]

    Michael, do you have an estimate on time for the ability to edit data in the user interface? And if not, can you suggest a workaround? Admin simply need to be able to access that data.

    Hey found this plugin.. you could edit the fields of the contact form database extension. https://cfdbplugin.com/?page_id=459. It’s just it’s not free you need to purchase it. But I guess It’s a great plugin though..

    btw, cheers with this plugin.. great!

    Right, I am providing editing plus add & delete column capability via that extension but for a fee. Now my wife won’t kill me for the countless hours I spent on the stuff I give away for free ??

    “I am providing editing plus add & delete column capability via that extension but for a fee.”

    Yes I paid the $50 fee and still cannot edit records. Only delete or add columns. And your plugin states, to unlock the editing feature I must pay this fee first, in which I did and still cannot edit records… All I have is a check box that says EDIT MODE DATA.

    If it is not working for you, I will try to work out the issue or give you a refund if your prefer.

    Are you having a situation where you try to edit data in a cell, but after you are done, it is not updated? I’ve seen issues like this which seems to be related to a MySQL issue where it tried to use an index but it doesn’t work right and gets no rows to update.

    OK,

    I am the dumb dumb. Plugin works great and I apologize for wasting your time… I was not trying to edit correctly…

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘[Plugin: Contact Form 7 to Database Extension] add info after form submited’ is closed to new replies.