Forums

i want steps to use google spreadsheet save.
or any other process to fetch and shoe the database on chronoform.

Hi yahire3388,

I split this into a new thread as you appear to be asking a different question.

There are DB Save and DB Read actions included in ChronoForms that will save/read records from database tables.

I have a GSheet Save [GH] action that will save records to Google Sheets if you need to do that.

Bob

@GreyHead

unfortunately I can't send you a PM (You can not send private messages yet.)
Could you please send me the GSheet action for saving Chronoforms data in google spreadsheets?

Best regards

Hi,

I need help with saving data into a google spreadheet, so I have some questions:

1.) The standard action of C5 doens't work anymore, because of changes by google, right?
2.) Got Bob's GSheet action, but can't create a p12 key at google developers console any more. What do I have to in the P12 key instead?
3.) How do I have to prepare the spreadsheet, I mean how do I have to format the columns/fields where the data should be placed? Anyone with an example?
4.) Is it even running in J2.5 or just in J3

Thanks for any request!

Hi Scolex,

1. Yes

2. As far as I can see you can still create a P12 file following the instructions here

3. The column names in the GSheet should match the names in the $form->data sub-array that you are saving; and the types should match up if you are using some columns with special formats.

4. As far as I know it will run in CFv5 on either Joomla! 2.5 or 3

Bob

hi Bob, I have the same doubt, I cannot understand how to prepare the GSheet. Can you please explain in detail?
where must i put th names of the fields i used in the form?
thanks

Hi phormann ,
​
The names of the fields need to match the names of the columns in the GSheet. Please see this FAQ
​
Bob

Hi GreyHead Save in google sheets working like a charm.
​
But how i save in both? GSheet and database table.
​
I ask because i need data in both tables
I tried to use database save together Gsheets and only saves in Gsheets not in database table.
​
sorry my english
​
​[file=10578]GSheet_screen.PNG[/file]
​[file=10579]DBSave_Screen.PNG[/file]

Close this post pleas i foud my mistake
​
Just create a table with the same name of colums of Google sheets both in Gdrive and DataBase table