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!
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.
)
)
)
Hi,
It looks like your sheet fields names are in lower case and this doesn't match the form fields names ?
Regards,
Max
It looks like your sheet fields names are in lower case and this doesn't match the form fields names ?
Regards,
Max
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!
From what i can see the array seems to be empty, nothing gets saved in it in the first place!
Please ensure that the letters cases match every where, you have the date Path set to "Gsheet" but the fields names use "GSheet"!
This topic is locked and no more replies can be posted.