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

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

    Asked by CCOTP 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

    or

    b) create a time only field

     

     

     

  • Profile Image
    JotForm Support

    Answered by idarktech on January 14, 2013 at 12:57 AM

    Hi,

    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.

    Thanks!

  • Profile Image

    Answered by CCOTP 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?

    Regards
    Mark

  • Profile Image

    Answered by CCOTP 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
    JotForm Support

    Answered by idarktech on January 14, 2013 at 10:34 PM

    Hi,

    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.