Michael Simpson

You can open up the security settings, so that users don’t have to authenticate. Just understand that all data is readable by someone creating the right URL.

CFDB does not send any email. The form plugin that you use does (such as Contact Form 7). See if you can do this with the form plugin.

There is no support in the plugin to write to a different table or format. If you get someone to help program, then you should tell them what the format your table should be in and that person should make the code to insert into it.

Somewhat related, FYI: if you go to the CFDB Options page, there is an option to display the pivot query on the administration page. Then you can see what SQL is being used to organize the data as you see it in the table on the administration page.

CFDB doesn’t have a way to save numbers 1, 2, 3, … to number each incoming form submission.

…I see the form name is in your query above: Confirma??o

Try renaming the form “Confirmacao”, do a submission, and see it you can view the entry.

What is the name of the form that is not showing results? I suspect special characters like quotes might cause the retrieval query to fail.

If you want to save a new form submission to a different table each time a new submission arrives, then you would need to add PHP code to a WP hook to write to your table. The hook is described in Manipulating Form Data Before it is Saved. But the code to save to your table is up to you to write.

Try sum(Weight,10) or diff(Weight,10)

A number with a comma in it such as 10,0 will be seen as 2 arguments

What does “block the header” mean?

The shortcode does output the text with the line breaks. But when put in an HTML page, the browser ignores extra whitespace. With your WordPress editor in “Text” edit mode (not “Visual”), put your shortcode in an HTML PRE tag to tell the browser to show all whitespaces:

<pre>[cfdb-value form="Recommend a new Surf-Hostel" show="Why-do-you-recommend-this-Surf-Hostel-Wh" limit="0,1"]</pre>

The filter expressions are sometimes evaluated in MySQL but in the case of regular expressions they are evaluated in PHP as a second pass over the results that MySQL returns. This is for parts of the filter that cannot be expressed in SQL. But maybe you can work out something that is close enough.

The CFDB function that you added only makes the new Myid field for CFDB in its own local copy of the form submission. That change is not seen by any other plugin. Ignore the CFDB example and follow a Form To Post example like the following.

function f2p_add_new_id( $form_data ) {
    $form_title = 'YOUR FORM NAME'; // Change this to your form name
    if ($form_data->title = $form_title) {
        $form_data->posted_data['post_title'] = "My ID is {$form_data->posted_data['Myid']}";
    }
    return $form_data;
}
add_filter( 'form_to_post_form_data', 'f2p_add_new_id', 10, 1 ); 

I think that your server is running out of memory trying to process all of those results.

You might try creating a private page with a form to search the DB which displays them in an editable datatable.

The error seems to suggest that wordpress could not load script that are included with the CFDB install. Maybe try to uninstall and re-install.

• This reply was modified 7 years, 7 months ago by Michael Simpson.

Currently there is no integration with Mail Chimp