Google Integration: Matrix results will show HTML code into the spreadsheet

  • Profile Image
    robyncotter
    Asked on March 01, 2013 at 11:02 AM

    I'm having my form send results to a Google Drive spreadsheet. In one of the fields, there is excess code instead of results.

    It looks like this in one field of the spreadsheet

    "<table cellpadding=""0"" cellspacing=""0"" border=""0""><tr><td>Individual Registration (Amount: 125.00 USD)<br>Total: $125.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>Carolyn</td></tr><tr><td><b style=""color:#777"">Last Name</b> </td><td>Sells</td></tr><tr><td><b style=""color:#777"">E-Mail</b> </td><td>jim.sells@att.net</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>Carolyn Sells</td></tr><tr><td><b style=""color:#777"">Street</b> </td><td>4835 Stewarts Ferry Pike</td></tr><tr><td><b style=""color:#777"">City</b> </td><td>Mount Juliet</td></tr><tr><td><b style=""color:#777"">State</b> </td><td>TN</td></tr><tr><td><b style=""color:#777"">Zip</b> </td><td>37122</td></tr><tr><td><b style=""color:#777"">Country</b> </td><td>United States</td></tr></table></td></tr></table>"

     

    That field should only contain the type of registration and dollar amount.

    I can't fit the entire field into a screen shot. I'm sending enough to give an idea. 

     

    Thanks,
    Robyn 

  • Profile Image
    pinoytech
    Answered on March 01, 2013 at 11:41 AM

    Hi Robyn,

    We apologize for the inconvenience that may have caused. Let me forward this issue to our next level support to investigate further the issue. As soon as this issue sorted out, we will inform you immediately.

    Thank you!

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

    Robyn,

    I have just released a fix for this bug. Furthermore, I have made it so that payment data is separated into three columns, namely 'Products', 'Payer Info', and 'Payer Address'.

    Please do check it out and let us know what you think.

    Regards