Skip to main content
Question

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 =1


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




------------------------------
Wade Myers
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement