When taking a payment with paypal, data all goes in one cell on spreadsheet

  • Profile Image
    habitatjackson
    Asked on September 22, 2012 at 07:05 PM

    I am still working on our poinsettia order form. I have hooked it to my gmail account to put all the order info into a spreadheet but when I get an order from Paypal it looks like this all in one cell:

     

    "<table cellpadding=""0"" cellspacing=""0"" border=""0""><tr><td>Poinsettia (Quantity: 1, Color: Red)<br>Total: $1.00<br></td></tr><tr><td><br />

    <table cellpadding=""0"" cellspacing=""0"" border=""0"" style=""font-size:10px;""><tr><td colspan=""2""><b style=""color:#777; font-size:12px;"">==Payer Info==</b></td></tr><tr><td width=""70""><b style=""color:#777"">First Name</b> </td><td>Laura</td></tr><tr><td><b style=""color:#777"">Last Name</b> </td><td>****</td></tr><tr><td><b style=""color:#777"">E-Mail</b> </td><td>****.laura@****.com</td></tr><tr><td colspan=""2""><b style=""color:#777; font-size:12px;""><br>==Address==</b></td></tr><tr><td><b style=""color:#777"">Name</b> </td><td>Peter Velasco</td></tr><tr><td><b style=""color:#777"">Street</b> </td><td>Brgy. Uno,</td></tr><tr><td><b style=""color:#777"">City</b> </td><td>Katipunan</td></tr><tr><td><b style=""color:#777"">State</b> </td><td>Zamboanga del norte</td></tr><tr><td><b style=""color:#777"">Zip</b> </td><td>7109</td></tr><tr><td><b style=""color:#777"">Country</b> </td><td>United States</td></tr></table></td></tr></table>"

     

    I was hoping for something more usable than this kind of info.

    thanks for any info.

  • Profile Image
    idarktech
    Answered on September 22, 2012 at 09:43 PM

    Thanks for reporting.

    I have now raised this issue to our developers. They'll reply to this thread once the problem is fixed.

    Apologies for the inconveniences caused.

  • Profile Image
    habitatjackson
    Answered on September 23, 2012 at 06:10 PM

    I hope it is soon, i need to make this form and for it to be useful. thanks

  • Profile Image
    nalamdana
    Answered on October 27, 2012 at 03:25 PM

    Bumping this topic... was SO excited to use the ready-to-go Jotform Paypal integration and GoogleSpreadsheets integration... only to get that same HTML/row/column jumble, which is only usable if I write some complicated filter to parse out the needed data...

    Please pretty please?

  • Profile Image
    jonathan
    Answered on October 27, 2012 at 03:41 PM

    Thank you for updating the topic. Your response have been forwarded to our dev team. We can only wait for now when this feature will be updated.

    You will be informed as soon as possible.

    Thanks.

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

    Everyone,

    The problem with the 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 feedback.

    Best regards