- tgbamAsked 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?Page URL:
- BenAnswered 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?
- tgbamAnswered on April 24, 2015 at 09:09 AM
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).
- CharlieAnswered on April 24, 2015 at 11:47 AM
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.
- tgbamAnswered on April 26, 2015 at 01: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.
- JotForm SupportBJoannaAnswered on April 26, 2015 at 02: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:
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.
- alp_denizAnswered on April 26, 2015 at 07:39 PM
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.
- tgbamAnswered on April 28, 2015 at 03:28 AM
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.
- CharlieAnswered on April 28, 2015 at 09: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:
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.
- tgbamAnswered 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.
- CharlieAnswered on April 28, 2015 at 01: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.