Hi,
I would like to export data from checkbox group into Google sheet.
The problem is in the checkbox group field name:
Field Name tag includes brackets - product[]
Google sheet tag includes brackets - Gsheet[]
So in the final version, it should look something like this Gsheet[product[]]. But this - of course - doesn't work. Any idea how to do it? Thanks.
I would like to export data from checkbox group into Google sheet.
The problem is in the checkbox group field name:
Field Name tag includes brackets - product[]
Google sheet tag includes brackets - Gsheet[]
So in the final version, it should look something like this Gsheet[product[]]. But this - of course - doesn't work. Any idea how to do it? Thanks.
Hi Nemec,
It should be:
Regards,
Max
It should be:
Gsheet[product][]Regards,
Max
You will need a "Handle arrays" action before the "sheet save" action, also you will need the handle arrays update, please send me a message using the "Contact us" page to get the latest file!
Regards,
Max
Regards,
Max
Hi,
I installed the newest version of Chronoforms V5. Now in Google Sheet I see text "
Screenshot of my settings:
http://2imgs.com/2i/i/54d671e5/f803e0ae1bfe8c74b6dc69b4b57f1501/55580d27f4.f.jpg
Thanks,
Nemec
I installed the newest version of Chronoforms V5. Now in Google Sheet I see text "
ArrayScreenshot of my settings:
http://2imgs.com/2i/i/54d671e5/f803e0ae1bfe8c74b6dc69b4b57f1501/55580d27f4.f.jpg
Thanks,
Nemec
The image doesn't load!
Do you have the handle array action before the sheet save action ?
Do you have the handle array action before the sheet save action ?
Data from Debugger:
Data Array:
Errors:
Data Array:
Array
(
[option] => com_chronoforms5
[chronoform] => Test
[event] => submit
[GSheet] => Array
(
[options] => Array
(
[0] => Option1
[1] => Option2
)
[name] => John
)
[button3] => Submit
)Errors:
Array
(
)
The "Handle arrays" action should be right above the "Sheet save" action, in the same event!
I am sorry It was old screenshot. I tried to add it into onSubmit event (before Gsheet event and also on the top). I also tried into onLoad event (on the top). But I always got only "Array" value.
http://files.lanete.cz/form2.jpg
http://files.lanete.cz/form2.jpg
Hi Němec,
I know that Max changed the Handle Arrays code in the latest release to resolve some problems with CC. I think that may be affecting your code here. Please try adding a Custom Code action and drag it up before the GSheet Save:
Bob
[[>> later: updated to correct GSheet <<]]
I know that Max changed the Handle Arrays code in the latest release to resolve some problems with CC. I think that may be affecting your code here. Please try adding a Custom Code action and drag it up before the GSheet Save:
<?php
$form->data['GSheet']['options'] = implode(', ', $form->data['GSheet']['options']);
?>Bob
[[>> later: updated to correct GSheet <<]]
Hi Bob,
It works! Thanks. Thanks. Thank you very much!
I had to change only "Gsheet to GSheet" in your code. It's sensitive to uppercase and lowercase letters.
Regards,
Němec
It works! Thanks. Thanks. Thank you very much!
I had to change only "Gsheet to GSheet" in your code. It's sensitive to uppercase and lowercase letters.
Regards,
Němec
Ok, this is now confirmed a bug in the "handle arrays" action, the inner array should have been handled automatically!
This topic is locked and no more replies can be posted.
