Google Spreadsheet shows faulty dates for made submissions

  • tgbam
    Asked on April 22, 2015 at 7:31 AM

    The issue of the faulty submission dates in google drive is still persisting, even after reintegration. On top of that, the answer fields for names remain blank.

     

    I read somewhere that this might be due to spreadsheet applications installed on smartphones? Is this correct?

  • Ben
    Replied on April 22, 2015 at 11:09 AM

    If I understood you correctly, you are experiencing an issue with the dates being of wrong format when their data is entered into the integrated spreadsheet.

    If that is correct, could you please take a screenshot of your current spreadsheet local details and of the issue?

    Thank you.

  • tgbam
    Replied on April 24, 2015 at 9:09 AM

    Google Spreadsheet shows faulty dates for made submissions Image 1 Screenshot 20As you can see, the submission dates don't make any sense. Also the names are left blank (i filled in the last 5 by hand, and left the last entry blank for you to see).

  • Charlie
    Replied on April 24, 2015 at 11:47 AM

    Hi,

    I've cloned your form and made a test submission, unfortunately, I'm unable to replicate the problem. I also see that you you had this problem recently. Our developers mentioned that there's an update from Google that affected the integration.

    Could you try the following.

    1. Remove integration

    Google Spreadsheet shows faulty dates for made submissions Image 1 Screenshot 20

    2. Clear your Form's Cache.

    3. Clear your Browser's cache

    4. Refresh page and log back in.

    5. Re-integrate Google Spreadsheet and see if that resolves the problem.

     

    I know you have already re-integrated, but please do try again, or you could also try cloning your form using this guide: http://www.jotform.com/help/27-How-to-clone-an-existing-form-from-your-account. Integrate Google Spreadsheet on that cloned form and see if the problem persist.

    Kind regards.

  • tgbam
    Replied on April 26, 2015 at 1:29 PM

    I deleted the integration, cleared the caches and reintegrated again.

    The problem with the "blank" names seems to have been resolved. However, when a new entry is made, the date is again non-sensical. Furthermore, when copied via a query formula, the submission dates are replicated as some strange code. See attachements for examples.Google Spreadsheet shows faulty dates for made submissions Image 1 Screenshot 30

    Google Spreadsheet shows faulty dates for made submissions Image 2 Screenshot 41

  • BJoanna
    Replied on April 26, 2015 at 2:14 PM

    Considering that you are using Query formula to copy submissions from one tab to other I assume that there is a problem with formatting inside of that new tab. 

    Highlight the "Submission Date" column > Click "More Formats" in number button > Click "More Formats" in the dropdown options > Click "Custom Number Format" option:

    Google Spreadsheet shows faulty dates for made submissions Image 1 Screenshot 30

    Paste: d/M/yyyy H:mm:ss to the Number format box and click "Apply" button:

    Google Spreadsheet shows faulty dates for made submissions Image 2 Screenshot 41

    That should fix the formatting. 

    Considering other issue  with non-sensical dates I can not reproduce it, are you still facing the same problem?

    Looking forward to your reply. 

  • alp_deniz
    Replied on April 26, 2015 at 7:39 PM

    Hello,

    This issue has recently been identified and it is caused by applied "Locale" in Google Spreadsheets or some Google apps that reformats all of the sheet. 

    If you remove the app or locale setting that breaks the format and re-integrate, the dates will be in the format of your preference.

    Kind regards

  • tgbam
    Replied on April 28, 2015 at 3:28 AM

    Hi alp_deniz,

    Yours seems like an interesting solution. My location setting is already blank and it seems i am not able to change my time-zone setting. 

    How would i go about removing the "app" setting? I don't know exactly what it is your referring to.

     

    regards

  • Charlie
    Replied on April 28, 2015 at 9:28 AM

    I believe he is referring to an add on or an app that you integrated to change the date format, you'll need to remove it. 

    To see the list of apps you're using you can check the screenshot below:

    Google Spreadsheet shows faulty dates for made submissions Image 1 Screenshot 30

    See if there's an app that changes the format of your Google Spreadsheet.

    Also, could you try re-setting the time settings in your JotForm account, see if that fixes the problem, but I would suggest that when you make changes try to re-integrate to see a more accurate result.

    Google Spreadsheet shows faulty dates for made submissions Image 2 Screenshot 41

     

    See if that helps. Thanks.

  • tgbam
    Replied on April 28, 2015 at 11:59 AM

    I have absolutely no idea which "app" might be influencing the submission dates. Most of the apps involved seem to be essential to the process, and the others i've never used or even seen before.

  • Charlie
    Replied on April 28, 2015 at 1:50 PM

    Unfortunately, it will depend in your settings to what might be affecting it. You could start from disconnecting those that are in someway related to the Google Spreadsheet, but not the spreadsheet itself. 

    You could try repeating the solutions above and see if it changes anything, if re-applying the solutions did not solve the problem we can further investigate it. We'll wait for your response.

    Apologies for the inconvenience, we appreciate your patience and cooperation on this matter.