Google Spreadsheet: missing Submission Date in the spreadsheet file

  • Profile Image
    akalikin
    Asked on March 25, 2019 at 07:10 AM

    Almost week ago there are no submission date and time exported to Google Sheets

    Please fix it

  • Profile Image
    Welvin
    Answered on March 25, 2019 at 08:34 AM

    Are you referring to the system submission date and time or the date and time fields from your form? Please confirm this.

    I cannot replicate the problem with system date and time, so I presumed you mean the date and time from your form.

    15535172082019-03-25-005.png

    Also, please share us the spreadsheet file so we can check the date/time there. Read-only permission will do for us. 

  • Profile Image
    akalikin
    Answered on March 25, 2019 at 09:41 AM

    Yes, I mean exactly the same that you show in cell A1 and A2, there no date in this field when new submissions are posted, but other fields fill properly

  • Profile Image
    Richie_P
    Answered on March 25, 2019 at 10:23 AM

    To clarify, is this the form in question https://www.jotformeu.com/form/72435496656367?

    I have tested a cloned version of your form and I can't seem to replicate the issue at my end.

    Can you please share to us your Google Sheet so that we can check the date/time?

    To share your Google Sheet, kindly follow this screenshot: Click on Share button on the upper right corner of your Google Sheet and click Get shareable link. Use the link given to share the Google Sheet.

    We will wait for your response.

  • Profile Image
    Richie_P
    Answered on March 25, 2019 at 10:49 AM

    Thank you for the added information.

    It seems the Google Sheet you have shared is not the shareable link. Click on the "Get shareable link" and use the link.

    Screenshot:

    Can you please try re-integrating your form with Google Sheet?

    To re-integrate your form, you would need to remove your Google Sheet Integration and add it again.

    Guide:-How-to-Integrate-Forms-with-Google-Sheets

    Please give it a try and let us know how it goes.


  • Profile Image
    akalikin
    Answered on March 25, 2019 at 10:54 AM

    1) Ok, I made link sharable without need to login

    2) I have made a clone of my form to show you, I after this a already made a integration from scratch 

  • Profile Image
    Welvin
    Answered on March 25, 2019 at 11:04 AM

    I also cannot replicate the problem with the Submission Date and Time. I would suggest removing the current integration and do it again to create a new sheet. See if that works. 

    Here's my cloned form https://form.jotform.com/90834846978982.

    The spreadsheet: https://docs.google.com/spreadsheets/d/1hEesJ41qQs0ncIJ2_Hvh2YPa0F0crCIKd8bJg3oNL9Q/edit?usp=sharing 

  • Profile Image
    akalikin
    Answered on March 25, 2019 at 11:06 AM

    I have posted in your form but as you see no submission date is filled.

  • Profile Image
    Richie_P
    Answered on March 25, 2019 at 11:20 AM

    Before we forward this issue to our back-end team, can you please try removing your Google Sheet Integration and add it again?

    To remove the Integration, go to Settings>Integrations>Google Sheet>Remove Integration

    Once you have removed the Integration, you may add it back again.

    Please give it a try and let us know if the issue still remains. If the issue remains, can you please share to us the new Google Sheet?



  • Profile Image
    Welvin
    Answered on March 25, 2019 at 12:26 PM

    That just weird, but it's confirmed now that the problem is to your end only. You can see, my test has the date/time in it. Check the old spreadsheet, my spreadsheet, and your current new sheet. All have dates on our test submissions.

    I have now escalated this thread to our backend team for further troubleshooting. If we have an update, you should know it here.

  • Profile Image
    serbay
    Answered on April 02, 2019 at 08:50 AM

    Hello akalikin,

    We have checked the issue which assigned by our support team.


    The problem was centered and the problem fixed programmatically. It looks working properly.

    Please try to send a test submission and if you encounter any more issues, re-integrate Google Sheets .


    Please keep us informed of your progress. 

    Regards.