Google Sheets records appear in the wrong place

  • Profile Image
    Crowdmanagement
    Asked on June 06, 2020 at 01: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

  • Profile Image
    KrisLei
    Answered on June 06, 2020 at 05: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.jpg

    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.