Conditional Logic for DateTime Field base on Day of the Week

  • Profile Image
    spartan02
    Asked on October 13, 2013 at 07:52 PM

    Hello,

     

    I know that the DateTime field can be used with conditional logic based on calendar dates.  Reference: (http://www.jotform.com/answers/225356-Using-DateTime-field-with-Conditional-Logic-based-on-current-date)

    I believe it would be useful if you can use the days of the week  as part of the conditional logic.

    For instance, If Today's Date is equal to "Sunday", then show X, Y and Z fields.

    Is this possible? Or can this functionality be added?

     

    Thank you.

  • Profile Image
    Welvin
    Answered on October 14, 2013 at 03:32 AM

    Hi,

    You can define the dates that corresponds to Sunday. So for example, if the Sunday's date is October 20, 2013. You can have your conditional logic as follows:

    So if there are four (4) Sunday's in a month, you will have four conditional logic as well. NOTE that you can have dynamic dates as "today + 1" or "today - 1".

     

    Thanks

  • Profile Image
    spartan02
    Answered on October 14, 2013 at 11:15 AM

    Thank you.  This works, but I do not think it is not an efficient solution because it requires adding the specific date of every Sunday in a calendar year (or multiple years) if a person wanted to set up the conditions perpetually.  I have different conditions for each day of the week.  Therefore, I have to go through the entire calandar year and find the specific dates in order to use the solution suggested above.  Wouldn't it be easier so that we can say if today's date is equal to "Sunday", then show x,y and z fields? That way you don't have to set up conditions for each specific date.

     

    Please advise.

     

    Thank you.

  • Profile Image
    ardy0689
    Answered on October 14, 2013 at 12:43 PM

    Hello, I tried to come up with a direct workaround on this but I also came up with the exact solution what my colleague has given you. At the meantime JotForm has no feature like this for conditions based on Date Time field.

    There is a workaround which I can give you but it poses suspicion for your users as it uses PHP and modifying the Form ID url on the go. You will have to completely rely on the script and give them that link rather than the Form URL which gives user a feel of doubt regarding the authenticity of your forms.

    I could however escalate this for our development team to add this function on the future if this is what you want. Thanks

  • Profile Image
    spartan02
    Answered on October 14, 2013 at 12:45 PM

    Thanks for your efforts.  If you could escalate to the development team that would be great.

    Thank you!

  • Profile Image
    Welvin
    Answered on October 14, 2013 at 01:07 PM

    Thanks for the additional information above. I have now added this thread to our feature request list. We cannot give you any details for the timeframe but, you should receive a notification via this thread for any progress made into this.

    Thanks for the idea!

  • Profile Image
    Stevenbuller
    Answered on January 22, 2016 at 06:49 PM

    Please escalate this, I am trying to perfect a quoting system which will depend on the day of the week for our availability.  Please Please!
  • Profile Image
    Kevin_G
    Answered on January 23, 2016 at 01:40 AM

    Hi,

    I will assist you with your concern on this thread : http://www.jotform.com/answers/754009 

    Thanks.

  • Profile Image
    Welvin
    Answered on January 23, 2016 at 06:54 AM

    Thank you, Randy. If you need help with something else, let us know by creating your own thread. http://www.jotform.com/answers/answer.php?

  • Profile Image
    Welvin
    Answered on January 23, 2016 at 09:14 AM

    Actually, this is already marked as resolved to our end. But thank you for the help. That is greatly appreciated.

  • Profile Image
    Welvin
    Answered on January 23, 2016 at 11:56 AM

    Well, our developers are responsible for updating tickets if they release something. It's either the assigned developer just marked this resolved or the other dev - all without putting something that would notify the original poster. We apologize for that case. 

    As for your own thread. I'm sure, those will be updated soon. If you think you are not updated, kindly reply to the thread so we can make a follow up.

  • Profile Image
    Stevenbuller
    Answered on January 23, 2016 at 03:12 PM

    Thanks JotForm support for adding this functionality.  Much appreciated!

  • Profile Image
    Kevin_G
    Answered on January 23, 2016 at 08:40 PM

    Hi @grade4pagasa,

    Sure, we will do our best to keep you notified about the status of the features.

    Thank to you and @Stevenbuller for use JotForm.

    Feel free to contact us anytime if you need more help, we will be glad to assist you.

    Regards.