Conditional Logic for Date Time Field based on reoccurring monthly pattern

  • Profile Image
    Asked on January 24, 2015 at 01:08 PM

    Is there a solution for conditional logic that allows late fees after a date and time for monthly reservation patterns. For example, an event occurs monthly on the third Friday of every month. Reservations must be received by noon three days prior to the event. I want to Show/Hide reservation prices based on date and time for a recurring monthly event. Thanks,


  • Profile Image
    Answered on January 24, 2015 at 07:40 PM

    In addition to our colleague Shadae's solution, you can also try my version. 

    This one will let you have multiple Registration Events base on the date of the 'Event'


    Make certain evens only available 3 days before


    Make certain events only available 5 days before..

    here is the demo jotform

    This is the conditional statement used

    You can clone our forms to check it on your Form Builder

    user guide:



  • Profile Image
    Answered on January 24, 2015 at 09:40 PM

    Great answer!  I am a newbie to to JotForm and really appreciate the quick support.  Both solutions are great if the date is static or a singular event. The form I am trying to create (transitioning from AdobeFormsCentral) is a for a non-profit that holds meetings every month on the 3rd Tuesday. So, I want to be able to show regular pricing based on if the current date is three days by 12pm before the 3rd Tuesday; otherwise registrants have to pay a late fee.

    Is it possible to state something like the following:

    IF Current Date After "Third Tuesday- 4"

      AND IF Current Time After "12:00 PM"

    SHOW Select Event (late pricing)

    ***To reset pricing after the event and up to the next 3rd Tuesday*****

    IF Current Date After "Third Tuesday+1"

    SHOW Select Event (regular pricing)


    I am trying to work around SHOW/HIDE on a recurring event every 3rd Tuesday and whether registrants pay a late fee or not.

    Really appreciate any help. Otherwise, I have to remember to change the static date every month or try to pick all the dates for the year. 

    Thanks in advance for the assist!


  • Profile Image
    Answered on January 25, 2015 at 10:23 AM

    This functionality is common for most professional organizations that meet on a recurring time as found in calendar options. I hope that JotForm will work on a solution as having to update on a monthly basis is not efficient particularly for a volunteer organization where roles and responsibilities turnover. 




  • Profile Image
    Answered on January 25, 2015 at 12:34 PM

    Great.  I think this would be one more great robust form function that JotForm could offer where competitors do not.



  • Profile Image
    Answered on January 25, 2015 at 02:01 PM

    Thank you for letting us know.

    I understand that there was no week number functionality yet in the Date field calculation. I believe if you can calculate the current week number, then it will be simpler to build the conditional statement to get the day of a specific week.

    BUT isn't the 'Event date' is supposed to be static? I meant, if its an event in the future, then there should be at least a pre-determined date when it will occur. 

    You can now get the Day name base on a date (example: )

    So if you know the date and the day, you can build the conditional statement base on it.

    There is a feature request ticket also assigned to our developer base on this thread. We will do inform you once we have update on the progress of the request.

    Contact us anytime for any assistance you need on JotForm.



  • Profile Image
    Answered on January 25, 2015 at 02:14 PM

    Thanks Jonathan!

    Yes, the future dates are known.  Maybe a couple of exceptions during the holidays, but that could be addressed separately. 

    My thinking for now (like your own) until it is possible to set the condition up using a recurring day of the month, I could add 12 separate conditions representing the event date each upcoming month.  I have to look up every event date for now, but it is better than trying to remember to change the condition each month.


    I downloaded your form - Looking forward to updates.



  • Profile Image
    Answered on January 25, 2015 at 03:24 PM

    but it is better than trying to remember to change the condition each month.

    You also do not need to change the condition every time... you can actually just change the Date of the event on the deployed form.

    You can pre-populate the Event Date so that the date will changed.

    Since the conditional statement was base on the 'Event date' -- it should dynamically adjust also. 

    Example, If condition is set us "EventDate - 4days", then it should work every time.


    You can pre-populate the form date value using the Field Prepopulator App