Forum Discussion

SolaceSonder's avatar
Qrew Member
2 years ago

Checkbox in patient table if they have a certain symptom

Hi all,

I'm trying to write a field that checks a box in the Patient table when the Patient is associated with Symptom X. Table structure is currently patients can have 1:M symptoms. I want to have a field marked in the patient table if a specific symptom is present in this symptom list. 

Thank you!

Solace Sonder

1 Reply

  • np,
    Just go to the relationship where 1 PT has many Symptoms.
    Make a summary field based on "Any of" (the 2nd radio button)

    and limit the filer to that specific Symptom.

    It will make a clean checkbox field for you on the PT record.

    Mark Shnier (Your Quickbase Coach)