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

    Import Submisisons: How to import dates from a spreadsheet?

    Asked by exsfvid on March 08, 2016 at 10:13 AM

    JotForm equipment,

    Need support with the application import data since importo given in excel format, but the date is charged as a number, not forato date, which I will generate a problem with the calculation of conditional fields, not include the correct date.

     

    Page URL:
    https://www.jotform.com/submissions/60673678041661

  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 08, 2016 at 01:17 PM

    I have been making some tests, created a form only with the date field, I made some submissions and then imported the data, seems like you need to import the date using this format: 2016-12-31. 

    Also, you need to format the cell as text.

     

    I did it and worked on my end:

    Hope this helps.

  • Profile Image

    Answered by stevedellar on April 23, 2016 at 06:18 AM

    So basically you cannot import a date.  you have to type the date as yyy-mm-dd as a text field.

    That is not practical when you have over 3000 dates to import.

     

    We need to be able to import dates copied from a speadsheet in date format not text.

     

     

  • Profile Image
    JotForm Support

    Answered by liyam on April 23, 2016 at 07:27 AM

    Hello, 

    Instead of replacing the format per cell, you can actually select all fields in that column and then do the same process of changing the format. So with just changing the format of the column once, it will change the format of all 3000 or more data in just a few clicks.

    Here is a sample animated GIF on how to change the formatting of all the data in one column: 

    If you have questions, please do let us know.

    Thanks.

  • Profile Image

    Answered by exsfvid on April 25, 2016 at 07:51 AM

    Hello Liyan,

    One question ... these gif beams JotForm with some application or some other tool? ... I seem too good and explanatory. Would you give me the data as them,

     

    Thank you very much.

    Greetings.

     

  • Profile Image
    JotForm Support

    Answered by Kiran on April 25, 2016 at 08:59 AM

    @exsfvid,

    We generally use LiceCap application to capture the desktop and save it as animated gif file. You may download it for free at the following link:

    http://www.cockos.com/licecap/

    Thank you!