Google Spreadsheet: Why is the integrated sheet empty?

  • ElysiaT
    Asked on November 13, 2017 at 2:49 PM

    Hi,

    When I try to integrate an existing form with google spreadsheets, it results in an empty file. Could you please help with this!

    https://form.jotform.com/72974403568264

  • Kevin Support Team Lead
    Replied on November 13, 2017 at 3:47 PM

    I have cloned your form and integrated it with Google Spreadsheet on my end, it seems to be working as expected here. 

    Google Spreadsheet: Why is the integrated sheet empty?  Image 10

    Is this not the same you're seeing on your end? 

    Please make sure you're logged into your Google account to view the spreadsheet and it's the same as shown on the JotForm integration wizard. 

    You may also provide us more details about how the sheet looks on your end, if possible, please also provide us some screenshots about it.

    This forum does not accept images through email replies so you will need to open it on a web browser and follow this guide: https://www.jotform.com/help/438-How-to-Post-Screenshots-to-Our-Support-Forum 

    We will wait for your response. 

  • ElysiaT
    Replied on November 14, 2017 at 10:16 AM

    Thanks for your prompt reply. That is the correct sheet that I'm seeing on my end. I am wondering if the columns (List of names of students)can be arranged in the way they are on the form (rows) as oppose to being columns. 

  • Kevin Support Team Lead
    Replied on November 14, 2017 at 11:25 AM

    Unfortunately, it's not possible to change the way how the data is sent to the sheet, each field will be displayed on a column and new submissions will create a new row. 

    Please avoid to make any change on the integrated sheet since this may corrupt the integration. 

    If you have more questions, let us know.