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

    Conditional Logic for Date Time Field based on reoccurring monthly pattern

    Asked by melanieb07 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,

     

    DateTime field date and time prices thanks solution
  • Profile Image

    Answered by Shadae on January 24, 2015 at 07:12 PM

    Hi melanieb07,

    To confirm, you would like specific fields to be shown based on the date and times that are selected on your form.

    If that is the case, that can be done using the Date Field, the time field and the before and after option in your conditions.

    I did a test form, showing how this would work. The cut off date for the higher price will be January 23rd after 12 PM.

    You can make the default time and date the current time and make the field read only. The field in my form is editable for testing purposes.

    You can view the form here: http://form.jotform.co/form/50236959670867 

    Here are the conditions are used to achieve the desired effect:

    I hope this helps, please inform us if you need further assistance.

  • Profile Image
    JotForm Support

    Answered by jonathan 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'

    Example:

    Make certain evens only available 3 days before

    OR

    Make certain events only available 5 days before..

    here is the demo jotform http://form.jotformpro.com/form/50237661000946?

    This is the conditional statement used

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

    user guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

     

    Thanks.

  • Profile Image

    Answered by EnergyExpress 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 by Shadae on January 24, 2015 at 11:09 PM

    Hi EnergyExpress,

    Unfortunately, it is not possible to set the condition to be for the "Third Tuesday" of each month.

    It would need to be a static date or a certain amount of days from the date that the form is filled out.

    The best option would be to edit the form monthly, or create a form for each month and make it available for each month.

    Please inform us if you need further assistance.

    Thank you.

  • Profile Image

    Answered by EnergyExpress 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. 

     

    Thanks,

     

  • Profile Image

    Answered by Shadae on January 25, 2015 at 11:44 AM

    Hi EnergyExpress,

    I have passed on your suggestions to our developers as a feature request. There is no estimated time on when this will be implemented.

    However any update on the request will be posted on this thread.

    Thank you.

  • Profile Image

    Answered by EnergyExpress 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.

     

    Thanks!

  • Profile Image
    JotForm Support

    Answered by jonathan 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: http://www.jotform.com/form-templates/show-day-of-the-week )

    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.

    Thanks.

     

  • Profile Image

    Answered by EnergyExpress 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.

    Thanks,

     

  • Profile Image
    JotForm Support

    Answered by jonathan 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

     

    Thanks.