Error on Google Spreadsheat Live Data Function

  • Charlieelcarlino

    (@charlieelcarlino)


    10 years, 11 months ago

    Hi there, Michael!

    Thank you very much for your awesome plugin. I was trying to sinchronize one form with Google Drive, but I’m facing some issues when the function is too long and has to be added as script.

    1) Do I have to choose “Complement” (or Addon, I see it in Spanish and I’m not sure how is translated) or “Custom function”? This is what I see: http://prntscr.com/7l82k6

    2) Do I have to save it with any special name?

    3) Do I have to replace anything in the code?

    4) Is this the correct function (of course with correct values replaced)?
    =cfdbdata("<url>", "<form name>", "<user>", "<password>", "show", "your-name,your-email,submit_time", "headers", "your-name=Nombre,your-email=Email,submit_time=Hora")

    I can’t understand why, but I keep having this #ERROR! thing…

    Thank you very much for your time!

    https://ww.wp.xz.cn/plugins/contact-form-7-to-database-extension/

Viewing 1 replies (of 1 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    10 years, 11 months ago

    (1) Choose “Custom function”. Then from the File menu, create a new script file. Paste the code and save.

    (2) No

    (3) Paste the code exactly. No replacements

    (4) Looks correct

    to try to debug: go to the code, change line 79
    return JSON.parse(content);
    to
    //return JSON.parse(content);
    return content;

    Try the function again and see if it give you more information about the error.

Viewing 1 replies (of 1 total)

The topic ‘Error on Google Spreadsheat Live Data Function’ is closed to new replies.