Spreadsheet to form widget is displaying the date as serial num

  • Profile Image
    GoofyCoolGO
    Asked on October 16, 2019 at 06:43 AM

    Previously my Dates in the Excel file uploaded to this widget, was able to display the Dates into a Short Text Field as text as seen in my Excel file,

    But seems recently the widget now only shows the Date as serial numbers instead of Date format as in Excel.

    Is there a way to have the widget display in Date format as per Excel?

    my test form: Text Excel

    thanks



    This is a re-post of a comment on How to Use the Spreadsheet to Form Widget

  • Profile Image
    AndrewHag
    Answered on October 16, 2019 at 07:18 AM

    The Spreadsheet to Form widget support only the fields which are mentioned in the guide. Could you please try populating the date into a Short Text Entry field instead of using the Date field?

  • Profile Image
    sdpcmedics
    Answered on October 25, 2019 at 02:46 AM

    I tried using the Short Text Entry field type in JotForm.. and importing my Excel column with dates into the form.. just like the previous from Goofy, they come up with date serial.

    Is there a way around this?

    What can we do to show an Excel column with a date inside, in the Jotform?  It would appear that Jotform always imports content of a cell as text.  Is this true?

    Would we need to convert any column of data (ex. Dates) into text format within the column to use the widget?


    Thank you!

  • Profile Image
    Kiran
    Answered on October 25, 2019 at 03:25 AM

    Could you share us with the form that you are working and a screenshot of the Excel spreadsheet with the date column and the Unique ID entered on the form so that we can check it further to assist you?

    We will wait for your response. Thank you! 

  • Profile Image
    sdpcmedics
    Answered on October 25, 2019 at 04:13 AM

    Thank you!

    I can only get the date to work if the XLS column for MoveIn is completely changed to a text column.. (Column C) if it remains as a date format (as in IT-Appt, column E), the date comes up with the "serial" or xls date counter number....

    the Unique ID is the Mkt Value - Column M.. seems to work fine to link and populate other bits.

    1571990720ssheet.JPG

    1571991084ssheet 2.JPG

  • Profile Image
    sdpcmedics
    Answered on October 25, 2019 at 04:50 AM
    Hi there!
    you guys rock...
    This is the form just as a test so far..
    https://www.jotform.com/build/92971600483965#preview
    I can only get the date to work if the XLS column for MoveIn is
    completely changed to a text column.. if it remains as a date format (as in
    IT-Appt), the date comes up with the "serial" or xls date counter number....
    Attached is my xls.
    Thanks!
    Matt
    ...
  • Profile Image
    sdpcmedics
    Answered on October 25, 2019 at 04:50 AM
    Sorry, the Unique ID is the Mkt Value - Column M..
    What else do you need?
    Matt
    ...
  • Profile Image
    sdpcmedics
    Answered on October 25, 2019 at 04:50 AM
    Do I reply to here or on the forum only?
    Sorry.. I wasn't sure which place to reply - your note just said a
    response? ;-) But, I see your note in the forum as well...
    I'll reformat my data and question for the forum in case it helps others.
    Matt
    ...
  • Profile Image
    jherwin
    Answered on October 25, 2019 at 06:30 AM

    I can see the issue you are referring to. That's right, you'll need to make the date in your spreadsheet or Excel as plain text for it to work.

    Currently, that's the only workaround so you can transfer the dates from excel to your form fields.