Home → Blog → WordPress →

Store Contact Form 7 Submissions in TablePress

July 10, 2020 WordPress 10 Comments
Contact Form 7 to TablePress

Here is a quick snippet of a PHP to store Contact Form 7 form submissions in TablePress tables. Make sure you update the form-to-table-ID mapping in $form_to_table_map array to match your setup:

add_action(
	'wpcf7_before_send_mail',
	function ( $contact_form ) {
		// Map Contact Form ID to Table ID.
		$form_to_table_map = [
			4 => 1,
		];

		$form_id = $contact_form->id();

		if ( isset( $form_to_table_map[ $form_id ] ) && class_exists( 'TablePress' ) ) {
			$table_id = $form_to_table_map[ $form_id ];
			$table_model = TablePress::load_model( 'table' );
			$table = $table_model->load( $table_id );

			if ( is_array( $table['data'] ) ) {
				$form_data = WPCF7_Submission::get_instance()->get_posted_data();
				$table['data'][] = array_map( 'strval', $form_data );
				$table_model->save( $table );
			}
		}
	}
);

On each form submission it checks if the contact form ID matches an existing table ID and writes all field values to a new row in that table.

Be sure to register enough columns to fit all of contact form fields!

Related posts:

  1. Export as CSV for Storage for Contact Form 7 Plugin
  2. Contact Form 7 Storage Plugin
  3. Version 0.2 of Contact Form 7 Controls

10 Comments

  1. Yann says:
    July 22, 2020 at 11:16

    Hello,

    I added your script but after submitting data from CF7:

    1. no data was sent to tablepress (*).
    2. it adds a code at the end of the url page such as #wpcf7-f11240-o2. So if you refresh the page, a resend message popups.

    TablePress id = 2

    so i updated script 

    $form_to_table_map = [
	4 => 2,
    Reply
    • Kaspars says:
      July 22, 2020 at 17:29

      That looks correct! Can you please confirm that your Contact Form ID is 4? If not, then change the 4 on the left from 2 to the correct form ID or add another pair of form ID mapping to a TablePress ID.

      Reply
      • Yann says:
        July 23, 2020 at 09:51

        TablePress got data from CF7 but the table doesn’t display data in frontend because your code is adding 2 extra columns at the end of the table, one being empty “”

        Example
        Column 1: Name – Peter
        Column 2: Email – email@email.com
        Extra column: 1 – 11241
        Extra column: “” – No

        Reply
        • Yann says:
          July 23, 2020 at 09:59

          I had to go to the backend to refresh first, then unhide the related row in tablepress in order to display data frontend. strange behavior :)

  2. Tommaso says:
    April 6, 2021 at 17:21

    This snippet works perfectly! Thank you a lot.

    Reply
  3. Scott says:
    October 7, 2021 at 17:50

    @Kaspars Thank you! This code works excellently!

    Text-based fields work as expected, however I have a problem with arrays (checkboxes, radios, etc). I checked the database entry and this code just adds the text “Array” as the value. I have tried to fix it myself with some loops but with no success.

    Can you provide an update that will parse the arrays into plain text?

    Reply
    • Kaspars says:
      November 8, 2021 at 20:28

      See this post for how to parse the form fields. Looks like you could check if the data is an array and transform it into a string like this:

      $form_data = WPCF7_Submission::get_instance()->get_posted_data();

$table['data'] = array_map(
    function( $field ) {
        if ( is_array( $field ) ) {
            return implode( ', ', $field );
        }

        return strval( $field );
    },
    $form_data
);

      I haven’t tested this so I’m not sure if it works and what is the format that TablePress expects `$table[‘data’]` to be.

      Reply
      • Scott says:
        November 28, 2021 at 22:15

        Thanks again Kaspars!
        In my case I’ve implemented your suggestion like so:

        if ( is_array( $table['data'] ) ) {
        $form_data = WPCF7_Submission::get_instance()->get_posted_data();

	//Grab the arch field
	$arch = WPCF7_Submission::get_instance()->get_posted_data( 'arch' );
	// Cast to array and join the array elements with a comma.
	$arch = implode( ', ', (array) $arch );
	// Write new value to form_data
	$form_data['arch'] = $arch;
	
	$table['data'][] = array_map( 'strval', $form_data );
	$table_model->save( $table );
}

        For now i’m grabbing the specific fields that I know need to be imploded, some dropdowns and a group of checkboxes. I’m wondering, if I’m not using the ', ' separator can I completely remove the first argument? My temp solution is to make it an empty ''.

        Reply
  4. Toby says:
    November 8, 2021 at 19:59

    Where does this snippet of code get added?

    Reply

Leave a Reply