Google Spreadsheet: Why is the integrated sheet empty?

  • Profile Image
    ElysiaT
    Asked on November 13, 2017 at 02: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



    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Kevin_G
    Answered on November 13, 2017 at 03:47 PM

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

    15106049901.png

    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. 

  • Profile Image
    ElysiaT
    Answered 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. 

  • Profile Image
    Kevin_G
    Answered 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.