Forum Discussion

JasonClark's avatar
JasonClark
Qrew Member
5 years ago

Date and Time Fields Triggered Required Fields

I am having trouble with required fields. I have a Delivery Date, Delivery Time, and Duration and I want any of them not being blank to trigger the other two (or all three) to be required. Duration seems to trigger Date and Time fine, but Time only triggers duration requirement and Date doesn't seem to trigger anything. I have tried several variations and even combining the form rules into one and make all three required. Thank you in advance.


1  When Delivery Date is not equal to «blank», require Delivery Time, and require Duration
2  When Delivery Time is not equal to «blank», require Delivery Date, and require Duration
3  When Duration is not equal to «blank», require Delivery Date, and require Delivery Time


------------------------------
Jason Clark
Business Intelligence Application Developer
PERRY proTECH
Lima OH
------------------------------
  • np

    I assume that you know that you can just make all the fields required on the form itself but I assume that what you were really saying is that when anyone of those three fields are entered you want to see the whole set of all three completed. It's OK to leave them all blank. 


    ... so "np"

    Just make 1 rule

    when multiple conditions
    when ANY .. of he following
    list the three fields not being blank
    field 1 is not _________________
    field 2 is not _________________
    field 3 is not _________________

    Action
    Require field 1
    Require field 2
    Require field 3


    .


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • JasonClark's avatar
      JasonClark
      Qrew Member
      Mark,

          You are correct. Its's all or none. Thank you very much. I didn't realize I needed to select "Multiple Conditions" at the top of the rule for the additional conditions to apply. I am still pretty new to this and learning. Thank you very much for the prompt response.

      ------------------------------
      Jason Clark
      Business Intelligence Application Developer
      PERRY proTECH
      Lima OH
      ------------------------------