Form Rule not firing off based on date field and formula field calculating age

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
I have a date field [Date of Birth] | a formula field that calculates the age [Age] & a dropdown field titled "Eligibility" (Eligible/Ineligible).

 The business rule is to change the Eligibility field to Ineligible if the Age is < 18. However, the form rule is not firing off the Eligibility field at all.
Photo of Steph Curry with the Base

Posted 2 months ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

Can you post your formula field code?
Doing this will fire off the form rule for the "Eligibility field"???

The formula that calculates the age is working just fine.
The [age] is already a formula number field
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
The eligibility checkbox should be a formula field and not a form rule.  Form rules do  not "fire" with the passage of time.  They only fire when a record is edited by a human user.  But, we all get a day older every day just through the passage of time. 
Sure, however, this forms' data is static, it is an application. The eligibility should not change over time if the age becomes greater than or equal to 18.
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb
formula check box field:

if([formula age calc field]>=[Eligibility Age],true,false)