Integrated Spreadsheet dumps data into one cell

  • BWEG
    Asked on May 15, 2019 at 1:59 PM

    I have some information that is not integrating on the google spreadsheet it dumps into that vendors have filled out on the jotform submission. Can you please tell me how to fix this. 

    Jotform Thread 1824573 Screenshot
  • Girish JotForm Support
    Replied on May 15, 2019 at 5:03 PM

    I cloned your form, integrated Google sheets and tested a submission. I was able to receive all the fields correctly in the spreadsheet. You can check my spreadsheet link here:

    https://docs.google.com/spreadsheets/d/1Q1HCByVLEIod9sSrMpNrTVgFCX-w1aCc55lJyDricwU/edit?usp=sharing

    Are you referring to the below field in the form, where you want the amount to be separated into a different column?

    15579540381505 14 Screenshot 10

    If yes, that cannot be done, since the spreadsheet integrates each field on the form and since the above-shown field is part of the Purchase order field, it will appear in this one cell.

    If this is not what you were referring to, please explain further on what you are looking to achieve.

  • BWEG
    Replied on May 15, 2019 at 5:43 PM
    I why is mine not showing like yours is? Do I need to do something
    different? I just want that information to be filled in. Here is what mine
    look like
    ...
  • BWEG
    Replied on May 15, 2019 at 6:14 PM

    I just the submitted information to show on the column in the google sheet. 

  • David JotForm Support Manager
    Replied on May 15, 2019 at 7:49 PM

    Your screenshot to illustrate the issue did not post on this forum thread, please follow this guide to share the screenshot: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum

    Please note that if the issue is about data not being sent to your Google Sheet, please try removing the integration, and making a new one: https://www.jotform.com/help/228-How-to-Integrate-Forms-with-Google-Sheets