Discussions

Back to discussions
Expand all | Collapse all

Evaluate if all records are true

  • 1.  Evaluate if all records are true

    Posted 25 days ago
    I have a form where I need to evaluate the condition of all records for a true condition. If all child records have been checked (Done), then the quantity of the formula in the parent table should be =1


    I attempted it with this formula: If([All WBS Tasks - Done]=true, 1, 0)




    ------------------------------
    Wade Myers
    ------------------------------


  • 2.  RE: Evaluate if all records are true

    Posted 25 days ago
    You need to have two summary fields.
    # of children
    # of completed children

    Then the formula for ​​the formula checkbox field 
    [All WBS Tasks - Done]

    would be

    [# of children] =  [# of completed children]
    and
    [# of children] >0

    I am assuming that if there are no children,  then you don't want the checkbox checked.



    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------

    Original Message