Date and Time Fields Triggered Required Fields

Question

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 ClarkBusiness Intelligence Application DeveloperPERRY proTECHLima OH------------------------------

MarkShnierYou · Answer

npI 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 rulewhen multiple conditionswhen ANY .. of he followinglist the three fields not being blankfield 1 is not _________________field 2 is not _________________field 3 is not _________________ActionRequire field 1Require field 2Require field 3.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

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

Sign up

Login to the community