Spreadsheet integration not writing records

Our (PayPal) Event registration form did not write entries from May 12 onward. Our event is on May 22 and I really cannot break the existing integration and start from scratch. Is there a way for you to extract the records from May 12 onward (its the dee Lagattuta record, Lisa Rossi form that date was recorded into a spreadsheet).

So in essence what i am asking for is to have a 2nd integration in another spreadsheet leaving the initial spreadsheet intact.

We will have a lot of registrations from now until the May 22 date. We do not have the manpower to do this manually.

Regards,

Hi events700,

Thanks for reaching out to Jotform Support. I've manually pushed the missing submission into your spreadsheet. Could you check if it is now reflected on your end?

Once we hear back from you, we'll be able to help you better with this.

Joeni,

Those entries are not in the spreadsheet. I took all filters off the <Form responses> tab in that workbook.

Debbie

Hi events700,

Can you tell us if you have made changes directly in your spreadsheet? If so, keep in mind that when a form is integrated with a Google Sheets Integration, it will continuously syncs new submission data. Directly editing the spreadsheet can disrupt this connection and cause data inconsistencies or lost updates. What you can do is to remove the existing integration and add it back again. Let me show you how to do it:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. In the menu on the left, click on Integrations and select the Google Sheets integration.
3. Then, hover over the Action section and click on the Three Dots icon.
4. In the dropdown menu, select Delete Action, and in the window that opens click on Yes, Discard.

Now, let's connect the Google Sheets Integration again:

1. While in Google Sheet Integration settings, click on the Add New Action button.
2. Now, select an action and click on Next.
3. Then, click on Add Action and customize settings as you want.
4. Once you finish customizing, click on the Save button at the bottom right of the settings.

If you select Create new spreadsheet, a new spreadsheet will be created in your Google account, where submissions will be collected. If you select Use existing spreadsheet, submissions will be collected in the spreadsheet you choose, which is already connected to your Google account. We also have a guide about How to Integrate Forms With Google Sheets that you can check out.

Reach out again if you need any more help.

If i connect to a new spreadsheet will the existing spreadsheet be impacted or will those records remain there? If your answer is yes to this I will copy the existing spreadsheet file to a new name and then remove the integration and this way I can just copy and paste (append) those records that were not written to the existing integrated file that I have renamed. I think this will work just asking because we cannot loose the work we did on those other tabs.

We only update different tabs in the integrated spreadsheet, not the <Form responses> tab.

Hi events700,

When you integrate your form with Google Sheets and choose an existing spreadsheet, it creates a new worksheet within that spreadsheet to store form data. This ensures that your other tabs, including any manual updates, remain unaffected by the integration. If you connect your form to a new spreadsheet, it will not overwrite or modify the existing spreadsheet or its tabs.

Copying the existing spreadsheet to a new file, removing the integration, and reconnecting it to the new spreadsheet is a solid strategy. This allows you to manually append the missing records to the renamed original spreadsheet without affecting any work done on other tabs. This will ensure your form submissions start syncing to the new spreadsheet without affecting your original file.

Give it a try and let us know how it goes.