Workaround for the issue where using CF7 Multi-Step Forms and Google Sheets Connector together adds duplicate entries to the spreadsheet

Table of Contents

• Workaround
• Steps
• What was happening

Workaround

For the phenomenon where data is sent twice, once for the confirmation screen and once for submission, we will temporarily give up on a direct fix.

Instead, we will ensure that the button text is entered into the "submit" column only upon submission,

(In this example, row 5 should be adopted)

By applying a filter to the "submit" column, you can display only the submitted information.

We will proceed with this approach.

Steps

You don't need to do anything special with the confirmation button on the input form.

<input type="submit" value="Confirm">

The goal is to set some `name` attribute for the submit button on the confirmation screen.

<input type="submit" name="submit" value="Send">

First, assign an `id` or `class` to the submit button from the Contact Form 7 editing screen.

[submit id:submit "Send"]

Make the confirmation screen form look like this.

This will output as follows,

<input type="submit" id="submit" value="Send">

Set the `name` attribute of the submit button with JS.

$("#submit").attr("name", "submit"); //Set the name attribute of the submit button to "submit"
/* == or == */
document.getElementById("submit").setAttribute("name", "submit"); //This is how you'd do it with vanilla JavaScript

With this, the "submit" information will only be sent upon submission.

Next, create a "submit" column in the spreadsheet (match it with the `name` attribute value).

The information will be entered like this,

Then, apply a filter to the "submit" column, and you're done.

What was happening

When "Contact Form 7 Multi-Step Forms" and "CF7 Google Sheets Connector" are used together,

At the timing of transitioning to the confirmation screen,

and at the timing of submission, information is sent to the spreadsheet,

resulting in the same information being sent to the spreadsheet twice.

It would be a nightmare if users repeatedly moved back and forth between the confirmation screen...

It's not certain, but it seems that according to the specifications of "CF7 Google Sheets Connector", information is sent to the spreadsheet when type="submit" is pressed,

and since both the button to transition to the confirmation screen and the submit button are type="submit", I believe the information is sent twice.

Comments