Google Sheets records appear in the wrong place

  • Crowdmanagement
    Asked on June 6, 2020 at 1:56 PM

    Hello,

    I use Google sheets which are automatically filled from JotForm. It works fine but unfortunately the new records appear above the header. How do I set the new record to be directly below the header?

    Sincerely


    Fred

  • KrisLei Jotform Support
    Replied on June 6, 2020 at 5:17 PM

    Hello Fred,

    I have cloned your form and made some test submissions while it is integrated into Google Sheets. However, I am unable to replicate the issue on my end, the new submissions always appear at the last row of the sheet. 

    1591477743submission Screenshot 10

    Have you made some changes on the spreadsheets or on the form fields? If it is, it could break the integration, so we really don't advise modifying the form or the sheets while there's an active integration. 

    You can try re-integrating the form to Google Sheets, this will generate a new integration link/file and all the submissions will also be included on the new sheet.

    Let us know if you have further questions.