Trying to schedule form to "go live" on a date and time by hiding fields

  • Barbara_Hesner
    Asked on February 10, 2021 at 8:06 PM

    I am trying to schedule a form to "go live" on a certain date and time and used this guide:

    https://www.jotform.com/answers/2379068-schedule-form-publish-date

    I set the date to current and the time to current, and said hide fields.

    I then set the condition if before 9:00 AM and before 2/12/2021 then hide most of the form fields.

    When I preview the form or use the form link all of the fields still show up including the date and time picker that are supposed to be hidden automatically.

    Jotform Thread 2890104 Screenshot
  • Girish JotForm Support
    Replied on February 10, 2021 at 10:28 PM

    I checked your form and it seems that it is working fine as I am not able to view any of the fields on the form:

    1613014112 6024a4604289e screencas110220 Screenshot 10

    Are you still facing any issues?

  • Barbara_Hesner
    Replied on February 11, 2021 at 12:07 AM

    I am still having issues. I sent the link: https://hipaa.jotform.com/210347965743159  to a person not with our company and all the fields showed up for them as well. I also viewed the form from my home computer and none of the fields are hidden. Ideas??

  • Vanessa_T
    Replied on February 11, 2021 at 2:43 AM

    I checked your form and was able to see fields within your form.

    1613027917 6024da4d2da1f b Screenshot 10

    If you'll notice, my computer time is already 03:17PM, as such, your condition to hide fields did not work on my end.

    Your current condition is set so that it will hide fields if time is before 09:00 AND date is before Feb 12. Both conditions need to be satisfied, since the time part is not satisfied, the condition to hide was not triggered.

    Unfortunately, I also could not find a way to enable the form based on a Date Picker and Time field. However, as a workaround, you can set your Date Picker to enable the Time.

    Then add a Form Calculation widget which will get the numerical value of a certain date/time.

    How-to-Perform-Form-Calculation-Using-a-Widget

    The numerical value for February 12, 09:00 AM is 18670.04, as such, in your condition, simply set it to show your fields if the numerical value is greater than 18670.03.

    How-to-Show-or-Hide-Fields-Base-on-User-s-Answer

    Please refer to my screencast below for the complete process.

    1613029287 6024dfa71d887 b Screenshot 21

  • Barbara_Hesner
    Replied on February 12, 2021 at 12:00 AM


    I set up a test form and first set the time stamp for 2/14/2021 at 8:00 AM and the fields were hidden. Yay, that's what I wanted, but I also wanted to test and see if the fields show back up when they are supposed to.

    I changed the time stamp to a time that has passed. First, 2/11/2021 8:00AM, then 2/10/2021 8:00AM using 1612972800, the fields are still hidden when they should show up.

    https://hipaa.jotform.com/210418643090146

    Is there a setting somewhere I'm missing? I used this site to calculate the day/time https://www.epochconverter.com/ I tried another site and it came up with the same number?


  • Vanessa_T
    Replied on February 12, 2021 at 1:08 AM

    The value returned by the Date Picker is in epoch days.

    Meanwhile, the value returned by the site you are checking is in epoch seconds.

    You need to convert seconds into days by dividing the value by 86400 so that your condition comparison works.

    Mastering-Date-and-Time-Calculation

    1613110104 60261b584aa85 03051 Screenshot 10

  • Barbara_Hesner
    Replied on February 12, 2021 at 1:26 AM

    Thank you! Your explanation of how to convert the date was exactly what I needed!!