Discussions

Expand all | Collapse all

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

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

    Posted 09-27-2018 15:59
    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.


  • 2.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:01

    Can you post your formula field code?


  • 3.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:02

    If(Today()>ToDate(ToText(Month([Date of Birth]))&"-"&ToText(Day([Date of Birth]))&"-"&ToText(Year(Today()))),
    Year(Today())-Year([Date of Birth]),(Year(Today())-(Year([Date of Birth])))-1
    )


  • 4.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:22
    This is not a formula date, it is a formula number. Change your data type for this field to formula number. Other than that, the formula is fine.


  • 5.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:27
    Doing this will fire off the form rule for the "Eligibility field"???

    The formula that calculates the age is working just fine.


  • 6.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:28
    The [age] is already a formula number field


  • 7.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:42
    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. 


  • 8.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:49
    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.


  • 9.  RE: Form Rule not firing off based on date field and formula field calculating age

    Posted 09-27-2018 16:53
    formula check box field:

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