JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Import Submisisons: How to import dates from a spreadsheet?Asked by exsfvid on March 08, 2016 at 10:13 AM
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.
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.
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.
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.
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.
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: