Google spreadsheet save

Hello!

I read all manuals about this feature and I still can't figure what to do.

The 'Data Path' refers to the ChronoForms $form->data array where the working data is kept. For example, if the data you want to export is in the $form->data['GSheet'] array then you'd put GSheet in the Data path box (which is the default value).

Where can I configure this Data Path? Where can I configure these arrays? Field ID in forms doesn't work. I tried many combinations and everything I get is this:

Array
(
    [GSheet Save [GH]] => Array
        (
            [0] => No data found to save
        )

My form is working very well, I'm receiving emails and database structure is ok. Only there I have the problem. What can I do?

Hello Fjodor,
I'm not a Chrono professional, but after checking your new post, I think that the following links may help:
How do I use the Google Spreadsheet Save action?
P.S: I'm just an automated service😉

Hi Fjodor,

What data exactly do you want to save? Please drag a Debugger action into the On Submit event, then submit the form and post the debug - including the 'dummy emails' results here.

Bob

I think I'm having the same problem.

Have copied the demo form for joomla registration and added the new beta action for google spreadsheet found here:
http://www.chronoengine.com/faqs/5233-how-do-i-use-the-google-spreadsheet-save-action

User is created in joomla but nothing is written to the spreadsheet.

This is my debug:

Data Array
Array
(
    [option] => com_chronoforms5
    [chronoform] => registrera
    [event] => submit
    [name] => test
    [username] => test
    [email] => xxx@xxx.xxx
    [patientbox] => 1
    [supporterbox] => 1
    [sjukdom] => dasd
    [password] => qwerty
    [vpassword] => qwerty
    [button6] => Submit
    [password2] => qwerty
    [_PLUGINS_] => Array
        (
            [joomla_registration] => Array
                (
                    [*isRoot] => 
                    [id] => 597
                    [name] => test
                    [username] => test
                    [email] => xxx@xxx.xxx
                    [password] => $2y$10$yp81DJrZNId4YSMzzSPbfOhw8peA8j26FvZGERGzrvcF5GF5Mp/O.
                    [password_clear] => qwerty
                    [block] => 1
                    [sendEmail] => 0
                    [registerDate] => 2015-09-01 13:44:22
                    [lastvisitDate] => 
                    [activation] => b1049dd9cd993a542bd0e1bfcabce0f5
                    [groups] => Array
                        (
                            [0] => 2
                        )

                    [lastResetTime] => 
                    [resetCount] => 
                    [requireReset] => 
                    [*_params] => Joomla\Registry\Registry Object
                        (
                            [data:protected] => stdClass Object
                                (
                                )

                            [separator] => .
                        )

                    [*_authGroups] => Array
                        (
                            [0] => 1
                            [1] => 9
                        )

                    [*_authLevels] => Array
                        (
                            [0] => 1
                            [1] => 1
                            [2] => 5
                        )

                    [*_authActions] => 
                    [*_errorMsg] => 
                    [*userHelper] => JUserWrapperHelper Object
                        (
                        )

                    [*_errors] => Array
                        (
                        )

                    [aid] => 0
                    [option] => com_chronoforms5
                    [chronoform] => registrera
                    [event] => submit
                    [patientbox] => 1
                    [supporterbox] => 1
                    [sjukdom] => dasd
                    [vpassword] => qwerty
                    [button6] => Submit
                    [password2] => qwerty
                    [usertype] => deprecated
                )

        )

)
Array
(
)
Errors
Array
(
)
Debug Info
Array
(
    [GSheet Save [GH]] => Array
        (
            [0] => No data found to save
        )

)

Hi lenny,

There's a clue at the end of the Debugger output.

What do you actually want to save to the Spreadsheet? You need to put that into a sub-array of the $form->data[''] array so that the action knows what to save. The sub-array can have any name but the examples usually use GSheet.

Bob

I want to save name, username, patientbox, supporterbox and sjukdom to the speadsheet.

Where do i put it into sub array? In the code tab of the form?

Hi Fjodor,

You could change the names of these inputs to GSheet[name], GSheet[username],. . .

Or you can add a Custom Code action before the Google Save action with code like this:

<?php
$save = array(
  'name',
  'username',
  'patientbox',
  'supporterbox',
  'sjukdom'
);
foreach ( $save as $s ) {
  $form->data['GSheet'][$s] = $form->data[$s];
}
?>

That should copy those items into the GSheet sub-array.

Bob

Bob, thank you for sharing this Custom Code. It's working for me now🙂