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.


  • Profile Image

    Google Spreadsheet: DateTime values incorrectly shown as a whole number in the spreadsheet

    Asked by xumanudi on September 08, 2015 at 08:58 PM

    I'm having problems integrating with Google Spreadsheet

    see the pictures, the issue date and time

     

     

     

     

     

     

    Page URL:
    http://form.jotformpro.com/form/52363352353956

    Screenshot
    date and time JotForm uploads
  • Profile Image
    JotForm Support

    Answered by Charlie on September 09, 2015 at 02:02 AM

    Hi,

    Apologies for the inconvenience. Could you try the following:

    1. Try resetting the Time Format and Time Zone in your account settings

    2. After that, try removing the integration then re-integrate it again. When you re-integrate, all of the submissions will automatically be loaded in your new spreadsheet.

    3. After that, in your new spreadsheet, navigate to File->Spreadsheet Settings

    Here, make sure to set the "Locale" and "Time Zone" dropdowns. 

     

     

    Save the changes and make a test submission.

    Let us know if that works.

  • Profile Image

    Answered by xumanudi on September 09, 2015 at 09:52 AM

    I've done this procedure and did not solve the problem.

     

    I need a solution

  • Profile Image
    JotForm Support

    Answered by Charlie on September 09, 2015 at 11:26 AM

    Apologies for the inconvenience. 

    Could you also try this one:

    On this column where the date is, navigate to Format->Number->Choose a DateTime format.

    See if that will give you a better result.

    I will also forward this to our developers to have it checked. We will update you on this thread when we hear any news.

  • Profile Image

    Answered by xumanudi on September 10, 2015 at 09:58 PM

    I did all of these procedures, and the problem NOT resolved.

     

    I created a new form with only date and time.

    and made integration with google spreadsheet

    and it did not work, the date and time

     

    http://form.jotformpro.com/form/52528256772967?

     

  • Profile Image
    JotForm Support

    Answered by Chriistian on September 11, 2015 at 04:22 AM

    Hi,

     

    This issue has been escalated to our Development team and is marked as "Very Important" priority. One of our developers is currently working on this bug. You will be updated here once the issue is fixed. Sorry for the inconvenience this may have caused you.

     

    Do let us know if you need further assistance.

     

    Regards.

  • Profile Image

    Answered by xumanudi on September 11, 2015 at 07:54 PM

    What is the time to solve the problem?

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 11, 2015 at 11:03 PM

    Hello,

    The problem is known and we are currently waiting for a component update to be able enable you to initiate integration with pre-formatted rows in case you have a locale set or an app clearing the format of the sheet. This will solve the issue here.

    I will work on it to complete it in a week and let you know right after.

    Thank you for your patience

  • Profile Image

    Answered by xumanudi on September 13, 2015 at 09:20 PM

    already fixed?

  • Profile Image
    JotForm Support

    Answered by Boris on September 14, 2015 at 09:22 AM

    Our colleague Alp is not online at the moment to confirm, but I can see that this bug is still marked as opened. I believe that our developers are still waiting for that component update, in order to complete things up on our end.

    We will definitely let you know through this thread as soon as it is finished. Thank you.

  • Profile Image

    Answered by xumanudi on September 21, 2015 at 03:19 PM

    What reason for the delay to solve the problem? sincerely, I will look for another form system.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 21, 2015 at 03:43 PM

    Hello,

    Please accept our humble apologies for the frustration. The solution have been implemented but was waiting for the component update -new integration wizard. I will make sure it is implemented today into the current wizard. 

    Regards

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 21, 2015 at 05:06 PM

    Hello,

    "Pre-format" option is now added to Google Spreadsheets integration, in order to bypass locale issues and insert pre-formatted rows. 

    I hope it works for you. Please let us know your thoughts.

    Kind regards