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

    Reading JotForm submission date from Google spreadsheet in Javascript

    Asked by resilico on September 10, 2015 at 08:29 AM

    Hello,

    I read JotForm submission data from a Google Spreadsheet, using Javascript. The submission date is shown in the Spreadsheet like a regular date/time, but when reading it in Javascript it shows up as a fraction, like 42125.61320601852. 

    When I try to convert this fraction using regular Javascript tools, it is translated into a date/time a few hours before January 1st, 1970.

    How can I convert submssion dates to a normal date/time strings?

     

    Kind regards,

    Nathan Moked,

    the Netherlands

     

     

    JotForm in style size font
  • Profile Image
    JotForm Support

    Answered by KadeJM on September 10, 2015 at 11:50 AM

    To my understanding you are attempting to read your submission data in your google spreadsheet using javascript which is converting the date|time to a fraction.

    What form is this for? I see you have several forms. Can you provide us a link or the name of the form that you are having this issue on? 

    Also, how do you have your script set to read it? And how are you trying to read it?

    Have you tried using zeros in front of the date format? That usually prevents the date from being converted into a fraction in some cases.

    Also, this can happen if you have your Spreadsheet set to replace text which is known to convert your data into fractions.

  • Profile Image

    Answered by resilico on September 11, 2015 at 10:46 AM
    I can circumvent the problem.
    Kind regards,
    Nathan Moked,
    The Netherlands
    Op 10 sep. 2015 17:48 schreef "JotForm Support
    Forum<jotform@jotform.com>"
    :
    ...
  • Profile Image
    JotForm Support

    Answered by Kiran on September 11, 2015 at 03:34 PM

    Great!! Glad you find a workaround for the issue that you are experiencing. Please do not hesitate to get in touch with us if you need any further assistance. We will be happy to help.

    Thank you for using JotForm!!