Buy Now
Sign in

Google spreadsheet save

yahire3388 , January 23 2017
Y
yahire3388
i want steps to use google spreadsheet save.
or any other process to fetch and shoe the database on chronoform.
GreyHead
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
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
S
Scolex
@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
S
Scolex
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!
GreyHead
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

ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
P
phormann

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

GreyHead
Hi phormann ,
The names of the fields need to match the names of the columns in the GSheet. Please see this FAQ
Bob
ChronoForms technical support
If you'd like to buy me a coffee or two, thank you very much
clovismmbr
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
Clovis Rolemberg
clovismmbr
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
Clovis Rolemberg