What is the best way to ensure users enter a time compatible with excel?

  • Profile Image
    Asked on January 13, 2013 at 11:26 PM

    To ensure users are enetering times correctly and reliably , I am having to use a DATETIME box, with the time enabled.

    When multiple times are required, the form can become quite crowded, and without a default time enabled, is quite lengthy to enter the date and time

    As I do not require the date part of this, are you able to either

    a) make it so we can remove the date from this


    b) create a time only field




  • Profile Image
    Answered on January 14, 2013 at 12:57 AM


    How about using the Range tool, it's under Survey tools? That might help. You can also set a default value as well.

    However, if you'd like to continue using the Date/Time field, we can help you remove its date fields using CSS Injection. Point to us the correct date/time field so we can help you removed the its date field.


  • Profile Image
    Answered on January 14, 2013 at 08:54 PM

    Thanks for your quick response.

    Unfortunately the range field doesnt do the job.

    I've managed to hide the date parts of the field using CSS injection, but this leaves me with another problem.
    I've made these *required fields, however the form wont submit (due to hidden date part unable to be filled in)
    I can allow the default date/time to be populated, but this then puts the current time in the fields.
    Having the current time auto populate, allows the user to submit the form without entering new correct data.

    Any ideas around this?


  • Profile Image
    Answered on January 14, 2013 at 09:02 PM

    There's also another reason for requiring a time only field.

    My form only requires certain scetions to be completed depending on the time of day.
    eg, section A asks for date and time
         section B is only required for times for before 9am 
         section C is only required for times after 9am

    You can only use the conditions to hide fields based on the date. Which would change each day the form is used.

    If I had a time field I could hide section B and C based on time entered in section A


    PLEASE PLEASE PLEASE add a TIME field :)

  • Profile Image
    Answered on January 14, 2013 at 10:34 PM


    I believed this is a good addition to JotForm. I'll forward this to our development team so they can consider this for implementation. Take note that our dev team are extremely busy nowadays since they are working on a new project so we can not provide to when this will be added.

    Also, I have tried the hiding the dates and actually you are right. They don't sumbit unlike the normal text box fields. Anyway, we'll let you know once this is implemented.

    Thanks for your cooperation.