Google Spreadsheet Integration: Product details are submitted as HTML not Text

  • Profile Image
    seikokai
    Asked on December 31, 2012 at 04:36 PM

    My form http://form.jotform.us/form/23130895527153 is integrated with Google Spreadsheets.

    The data coming in from Paypal is crammed in one column and buried in a bunch of HTML-style tabs I can't understand.

    My book keeper won't know how to deal with this and it generally just doesn't make sense.

    Can't the data just be dropped in individual columns for easy use? Why does jotform drop all this HTML into my spreadsheet?

  • Profile Image
    idarktech
    Answered on December 31, 2012 at 11:12 PM

    Hi,

    Thanks for reporting.

    The problem is already escalated to our development team. We'll let you know once it's fixed.

    Thanks and happy new year!

  • Profile Image
    idarktech
    Answered on December 31, 2012 at 11:27 PM

    By the way, I just would like to provide a tool for converting HTML to TEXT. Just for the meantime while waiting for the actual fixed. Here's one: http://beaker.mailchimp.com/html-to-text. Though, you have to convert them manually and paste it back to your Google Spreadsheet.

    Thanks and apologies for the inconveniences caused.

  • Profile Image
    NeilVicente
    Answered on March 21, 2013 at 06:24 AM

    Hi,

    The problem with HTML codes appearing on Google Spreadsheet has been fixed. Furthermore, we have separated payment data into three columns, namely 'Products', 'Payer Info', and 'Payer Address'.

    Kindly check it out and let us know your thoughts.

    Best regards