[GSheet Save [GH]] => 400 Blank rows cannot be written; use delete instead.

Hi,

I'm trying to save a Contact form data to Google spread sheet, but it's not working. The debugger say " [GSheet Save [GH]] => 400 Blank rows cannot be written; use delete instead.". I use this description https://www.chronoengine.com/faqs/70-cfv5/5233-how-do-i-use-the-google-spreadsheet-save-action.html and i installed the latest beta version ChronoformsV5 GSheet Save action.

URL: auguszt.ketsh.hu
PHP 5.4

Please help!

Hi ketsch,

I don't see any obvious problems. Please try moving the Debugger to just before the GSheet Save action to check that the data is still in the sub-array at that point.

Bob

Thanks for the quick reply!

Hi ketsch,

The data is there OK, but the $v printout at the end suggests that there is some debug code running in the action.

What is the date of the action you ? I'll PM you a link for the latest version.

Bob

Hello,

I've uploaded the latest version, but nothing has changed.

Hi ketsch,

Please take a Form Backup using the icon in the Forms Manager and post it here and I'll take a closer look.

Bob

Hi,

I have attached the form backup. It was made in Chronoforms 5.0.11.

Hi,

Did you have a chance to look at the form backup?

Hi bob,


Similar issue here. We have the gsheet working, no debugger on but on submit before the thankyou message we get the $v printout of the fields displaying. How can we stop this formatting without .gb3{display:none}

Test form is here on a staging site: http://mtech.sonley.co.uk/index.php?option=com_chronoforms5&chronoform=demo-basic-contact

Can PM login details if required.

thanks

Hi artonezero,

There was a line of debug code left in :-( I've sent you a PM with a link to the updated copy,

Bob