Evaluate if all records are true
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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYou 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
------------------------------
# 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
------------------------------