Nothing gets saved in DB or Gsheet

Andesch 08 Feb, 2015
Hi, have been sitting here for a few hours trying to understand what i'm doing wrong. Seems like that happen a little to often for meπŸ˜€ πŸ˜€

Anyway, I have tried with both accessing a Gsheet and saving in a DB but gets the same problem, where no data is added! I have been searching your FAQ and Forum but can't seem to find what i'm doing wrong!

Field names:
Gsheet[FirstName]
Gsheet[LastName]
Gsheet[SleepingArrangements]
Gsheet[DaysVisiting]

Data Path:
GSheet

Google sheet first row names:
FirstName
LastName
SleepingArrangements
DaysVisiting

And as can bee seen in the debugger code below, the google authentication is ok and the sheet is found, but there is noting in the array to put there!

Array
(
    [chronoform] => Forsamlingshelg
    [event] => submit
    [Gsheet] => Array
        (
            [FirstName] => ujl
            [LastName] => ul
            [SleepingArrangements] => l
            [DaysVisiting] => lu
        )

    [button5] => Submit
)

Array
(
)

Errors
Array
(
)

Debug Info
Array
(
    [2] => Array
        (
            [Google Spreadsheet Save] => Array
                (
                    [Authentication] => Success
                    [SheetURL] => Found!
                    [Columns] => Array
                        (
                            [0] => firstname
                            [1] => lastname
                            [2] => sleepingarrangements
                            [3] => daysvisiting
                        )

                    [AddResult] => Blank rows cannot be written; use delete instead.
                )

        )

)
Max_admin 08 Feb, 2015
Hi,

It looks like your sheet fields names are in lower case and this doesn't match the form fields names ?

Regards,
Max
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Andesch 09 Feb, 2015
They are in fact copies, it seems like the code converts it. However i tried with lower case and gets the same result..
From what i can see the array seems to be empty, nothing gets saved in it in the first place!
Max_admin 09 Feb, 2015
Answer
Please ensure that the letters cases match every where, you have the date Path set to "Gsheet" but the fields names use "GSheet"!
Max, ChronoForms developer
ChronoMyAdmin: Database administration within Joomla, no phpMyAdmin needed.
ChronoMails simplifies Joomla email: newsletters, logging, and custom templates.
Andesch 09 Feb, 2015
Thank you, that was in fact it! now it's working!
This topic is locked and no more replies can be posted.