How can I format a date field to not show options before a date in another field

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a table that tracks the process of a service order & when the service order is sent to each step in the process & when it exited a step in the process.  This allows us to calculate metrics that are critical to our operation.  Is there a way that I can format a date field to not have the option to enter a date before another date field.

For Example.  Let's say I have 2 date fields (Start & Stop).  The stop date can not be before the start date.
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
If the two fields on on the same record (same form), then you can use a Dynamic Form Rule that
when the record is saved
and conditions

[field B] is less than [field A]
Abort the save with message " blah blah blah"




Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
Thank you for the quick response.  I tried as you suggested but I must be doing something wrong because it is still letting me save the record even though [field B] is before [Field A]...


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
try uncheckng the non obvious checkbox at the bottom of the form rule

Fire "change" actions only when a condition changes from false to true
Photo of Amber Polston

Amber Polston

  • 582 Points 500 badge 2x thumb
There isn't a fire "change" action option on this type of rule...


Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,280 Points 50k badge 2x thumb
OK I guess you were right about that check box. I thought I tested it and saw it but apparently not. My last suggestion is instead of choosing the option when the record is saved, choose the option when the record is saved after checking.

I have never really understood the full difference between those two options but maybe that one will help.