Form is not forwarding data to Google Spreadsheet when US Dollar symbol is present to the field label

  • 2ga42adcy31
    Asked on October 7, 2014 at 12:48 AM

    Re-integration did load the previous missing values....however...when I submitted a new one, again the problem went back...no values for some of the fields.

    Also, re-integration created a new spreadsheet, not really a problem.

    Form is not forwarding data to Google Spreadsheet when US Dollar symbol is present to the field label Image 1 Screenshot 20

  • Welvin Support Team Lead
    Replied on October 7, 2014 at 7:09 AM

    Hi,

    After a few tests, I've found out that it was the US dollar sign preventing the form from forwarding data to Google Spreadsheet sheet.

    I have this thread forwarded to our developers. For now, I would advise changing your field label to "USD" instead of the "$" currency symbol. Then re-integrate the form to Google Spreadsheet.

    You will be notified via this thread when updates are available.

    Thank you!

     

  • alp_deniz
    Replied on October 8, 2014 at 7:24 AM

    Hello,

    The issue is identified and fixed immediately. Thank you very much for letting us know.

    Kind regards!

  • 2ga42adcy31
    Replied on October 16, 2014 at 5:00 AM

    Ok, now that the missing values have been fixed after removing the $ symbol....another issue came out of it.

    The column headings in the Google Spreadsheet have extra trailing character that I can't understand why it shows up. The labels in the form do not have it and yet it shows up.

    Form is not forwarding data to Google Spreadsheet when US Dollar symbol is present to the field label Image 1 Screenshot 20

  • 2ga42adcy31
    Replied on October 19, 2014 at 1:53 PM

    I have removed and re-did the integration, the issue of the trailing character is still there as shown in the screenshot below.

     

    Form is not forwarding data to Google Spreadsheet when US Dollar symbol is present to the field label Image 1 Screenshot 20

  • Jeanette JotForm Support
    Replied on October 19, 2014 at 5:56 PM

    Let me forward this to our developer Alp_deniz once again.

    Kind regards.