What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Google Spreadsheet shows faulty dates for made submissionsAsked by tgbam on April 22, 2015 at 07: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?
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?
As 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).
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
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.
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.
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:
Paste: d/M/yyyy H:mm:ss to the Number format box and click "Apply" button:
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.
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.
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.
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:
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.
See if that helps. Thanks.
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.
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.