Hello,

 

I am building a database for a hospital program and I have a table "patients" that is related to another table "tasks".

 

On the main layout I have a button that goes to the "tasks" records

 

In the tasks table each record corresponds to a task the doctor must complete for the patient its related to. There is a field that has a checkbox "completed"

 

I want the button to conditionally turn red when the at least one task is incomplete. where the field completed="completed" 

 

Is there a calculation step i can put in the conditional formatting that tells filemaker to check all of the related records in "tasks" to patients that are incomplete?

 

Thanks for help and if you need clarification dont hesitate to ask. 

Define the CF formula for the button as

Count ( Tasks::primaryKey ) > Count ( Tasks::completed )

 

Define the CF formula for the button as

Count ( Tasks::primaryKey ) > Count ( Tasks::completed )

Thank for the reply! This formula does work but it doesnt evaluate the count of the tasks completed that are specific to the patient. It looks up every record in the "tasks" table, not the records that are related to the specific patient. 

Thank for the reply! This formula does work but it doesnt evaluate the count of the tasks completed that are specific to the patient. It looks up every record in the "tasks" table, not the records that are related to the specific patient. 

OOPS! my Bad it worked. I put the wrong field in. Noob mistake. 

 

Thanks a lot!