Google Live data: shown as text not values in cells

  • Hi Michael et al,

    After getting Google Live Data to work with your gracious help, I couldn’t help but notice that the data is not shown in individual cells, but all values of all records are shown in a a single cell, enclosed in brackets. See the screenshot at https://prntscr.com/5nj1fu.

    I’ve been experimenting to see what I have been doing wrong, but can’t seem to find an option or so. Changed the location settings in Google Spreadsheets, but alas. Before messing about in the source code of the script, I’d figure to post it here first…

    Any help would be much-appreciated!

    Kind regards,
    Gijs

    https://www.ads-software.com/plugins/contact-form-7-to-database-extension/

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

    (@msimpson)

    Are you the person who was reported having an error on a different thread? If so, I had you change a line of code so that you could see the error. Change that back now that it is working.

    I, too, am having this error and haven’t made any changes to the code. It has been working for weeks, and then when I logged in today all the column fields are shown in one cell.

    Any suggestions?

    Thank you!

    Plugin Author Michael Simpson

    (@msimpson)

    I haven’t been able to reproduce this. It looks like you are seeing the raw JSON data.

    Try this, in the Google sheet script editor, add this function:

    function json_parse(cell) {
  return JSON.parse(cell);
}

    Then, if your data is showing in cell A1 for example, go to some other cell and enter in

    =json_parse(A1)

    and see if that displays the data correctly…

    Thread Starter greenemnl

    (@greenemnl)

    Hi Michael,
    I was indeed the one with the related question form the other day.
    I cannot get it to work with the regular code. It keeps giving the same error “Error: SyntaxError: Unexpected token: ? (line 79)”. When I use the code you suggested, i.e.
    ‘return content;’

    rather than the standard
    ‘return JSON.parse(content);’

    I don’t see an error message any more but rather all the content of the DB in a single cell. Obviously, I made sure that the password and other credentials have not been changed so do not seem to be the problem.

    Your latest suggestion above to Cardboardmonet did not work for me. With the standard script I still get the error message “SyntaxError: Unexpected token: ? (line 79)”, while the added function json_parse gives “Error: SyntaxError: Unexpected token: # (line 86)”

    Help is much appreciated, but I’ve somewhat given up at this point.

    Regards,
    Gijs

    Plugin Author Michael Simpson

    (@msimpson)

    OK. I’m wondering if the plugin is returning invalid JSON in some cases. If anyone would post (or email me at [email protected]) the text that is displaying, then I’ll take a deeper look.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Google Live data: shown as text not values in cells’ is closed to new replies.