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 se...
Forms
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
    5 years ago
    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
    ------------------------------