Submission Date and Time Stopped Showing up on my Google Sheet (Integration)

  • Profile Image
    webilac
    Asked on August 13, 2018 at 01:12 PM

    Hello, for a few days now I the submission date and time of my form submissions are not being transferred to my Google Sheet that I have integrated to the form. This worked just fine before and I didn't make any changes to the form nor the spreadsheet.


    I see the date and time on Jotform's (view submission) but not on Google Sheets.


    Help please!

    Screenshot
  • Profile Image
    Nik_C
    Answered on August 13, 2018 at 02:24 PM

    We're sorry for the inconvenience.

    I tried to manually push your submissions to your Spreadsheet integration, could you please check if submissions appeared and if the issue persists?

    We'll wait for your response.

    Thank you!

  • Profile Image
    webilac
    Answered on August 13, 2018 at 02:27 PM

    Hello Nik, thanks for the prompt reply. Unfortunately, the issue persists with the recent test I did, and I cannot see the missing data for the previous submissions.

  • Profile Image
    Nik_C
    Answered on August 13, 2018 at 03:34 PM

    Thank you for the additional information.

    I cloned and tested your form with my Spreadsheet integration, but I wasn't able to replicate this issue.

    What you could try is re-integrating of your Spreadsheet, but please be mindful that this will create a new Spreadsheet file, but existing submissions will be included.

    Let us know if that works for you.

    Thank you!

  • Profile Image
    webilac
    Answered on August 13, 2018 at 03:39 PM

    Hi Nik, is there any way to re-integrate to the same spreadsheet? Let me know if this is possible!

  • Profile Image
    EltonCris
    Answered on August 13, 2018 at 04:27 PM

    Unfortunately, it is not possible to reintegrate it on the same spreadsheet file. Currently, reintegration will create a new spreadsheet file.

    Anyway, I pushed the submissions data again from this form "Homestay Landing Page Leads" to its integrated spreadsheet. Would you mind checking it once again?

    Like my colleague, I also could not reproduce the problem on the cloned version.

    If the problem still persists, re-integration is the only option. This would create a new spreadsheet file with all the existing submissions in it.

    In case you want the data from the new spreadsheet to be synced on the old spreadsheet, you can use Google's importrange function https://support.google.com/docs/answer/3093340

  • Profile Image
    webilac
    Answered on August 13, 2018 at 05:00 PM

    Hi Elton, unfortunately, the data is still missing. I will reintegrate the form and share the new one with my colleagues.


    Thank you.

  • Profile Image
    EltonCris
    Answered on August 13, 2018 at 05:54 PM

    Sorry to hear that.

    Yes, please reintegrate, this should fix it.

    Regards