Update/Calculation Field Condition: ability to insert values in the Time(hour and minute) fields of the Date Picker field.

  • nrdadmin
    Asked on April 6, 2019 at 6:47 PM

    We're using Appointment Slots to set up appointment times for interviews. I'd like to be able to use the Google Calendar integration to get the date and time in our calendar. Using conditions I can input the date into the date picker form element. However, I can't get the time in the date picker. Is this doable, and if so, how would I do that? I don't want the interview to appear as a full day event on our calendar.

    Thanks!

  • Jed_C
    Replied on April 7, 2019 at 12:49 AM

    Yes, it is possible based on my test. What you need to do is pass the date and time value to a short text entry field and set the condition like this.

    1554612468The Easiest Online Form Builde Screenshot 10

    When integration, add the field into the description box.

    1554612507The Easiest Online Form Builde Screenshot 21

    Your output would be like this in Google Calendar.

    1554612539JotForm Inc Screenshot 32

    You can see in my screenshot that date and time is shown.

    I hope this helps. Let us know if you have any questions or if you need further assistance. 

  • nrdadmin
    Replied on April 7, 2019 at 11:18 AM

    Thanks for the response. However, I couldn't get it to work. I input the date and time into a short text entry field and put it into the description. However, it scheduled the interview for all day (the time was in the description, but not applied to the calendar).

    I then took the short text entry field and tried to pass the information to a date picker field. It accepted the date, but not the time.


    1554650194Screenshot (3) LI Screenshot 10


    Here is the form I'm experimenting with: https://form.jotform.com/90956692600160



  • David JotForm Support Manager
    Replied on April 7, 2019 at 2:56 PM

    I have tried to pass it too, even with the Date math function, but it did not work. It appears that the time part cannot be read through conditions. I have submitted a feature request to have the option to insert value in the Time fields of the Date Picker widget, however, there is no time-frame for implementation.

    You will be updated via this thread if this gest implemented in the future.