abdullah17

Hello @alvarogois ,
Thanks for getting in touch

While checking in the latest version, we didn’t noticed such issues, may be it happens due to google quota limit issues, you can refer to this
https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits

You can also enable the debug log and check out
https://www.gsheetconnector.com/how-to-enable-debugging-in-wordpress

Hope this helps!

@franciscoalfredomarcos
To confirm can you enable the debug log from wp-config.php and check the system status tab in the plugin, and also under integration tab while clicking debug view link.
Whenever entry is missing you will see an errors, just send us those errors to check and help you out further.

Thanks

@franciscoalfredomarcos

Please refer
https://www.gsheetconnector.com/how-to-fix-missing-entries-caused-by-google-quota-limits
for the fix.

Thanks
Abdullah

@mohobook

Can you please open up a ticket at our support for further guidance?

Thanks
Abdullah

Hello @mohobook,

After re-authentication, have to fetch the sheet details again?

If you have fetched and still not showing the sheets in the list then let us know which PHP and WordPress version you are using.

Thanks
Abdullah

Hello @franciscoalfredomarcos,

Thank You for getting in touch.

Can you confirm your integration is showing active under the Integration tabs?

While authentication you must give Google Sheets and Drive permissions.

Refer below Documentation
https://support.gsheetconnector.com/kb/wpforms-gsheetconnector-plugin-settings-free-version

once the authentication is showing active, then check after adding correct Sheet Name and Sheet Id, Tab Name and Tab Id, then only all your form submissions will be saved to the connected sheet.

If everything is correctly added and still entries are not showing in the sheet, then please enable the debug logs from your site and let me know with the errors.

I guess this might have happened due to the Google Quota limit also.

Let me know more.

Thanks
Abdullah

Hello @hotelwww,

Thanks for the confirmation that latitude and longitude are still not saved with negative and positive.

Can you email us [email protected]?and the temp staging site to take a closer look and help you further?

Thanks
Abdullah

Hi @hotelwww,

Due to security reasons, we have removed those characters but

Have you tried the following

Format -> Number -> Custom Number Format as -##.##########

Let us know if that doesn’t work.

Also, please let us know which type of Field ( Number, text ) you are using for the latitude and longitude data and which third plugin you are using for it.

Thanks
Abdullah

Hi @mohobook,

Can you confirm that the settings are not working or the data are not getting saved to the Google Sheet on form submission?

Thanks
Abdullah

Hello @jh-estudio,

Do you mean you are not able to see the settings or the headers or the data is not getting saved to the connected Google Sheet?

If settings are not displayed then make sure you have successfully connected with your Google Account.

And For the free version you have to manually add the header names to the Google Sheet. The headers are the form field label name.

Thanks
Abdullah

Hello @momokomay

Can you open a support ticket? Where we can provide you the files to debug in your environment and would be helpful for us to narrow down the issue.

Thanks
Abdullah

@momokomay and @markmelch,

Recently few of the users have rasied this issue, we are debbuging on it and provide the update as soon as possible.

Thanks
Abdullah

Hello @gosdend,

Thank you for letting us know about the issue.
We will fix it and provide an update.

Thank you
Abdullah

Hello @pilpoele,

May we know which other CF7 add-ons you are using along with GSheetConnector?

As the error doesn’t show anything related to GSheetConnector and also we are not using wpcf7_add_shortcode anywhere in our code.

Also, hope you are using the latest version of the plugin.

Thanks
Abdullah

Hello @epd,

Thank you for the details.

As per our chat on support, we have fixed the issue and will be releasing the plugin.

Thanks
Abdullah