Forum Discussion

SolaceSonder's avatar
SolaceSonder
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

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    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)
    mark.shnier@gmail.com
    ------------------------------