Getting Started

 View Only
Expand all | Collapse all

Checkbox in patient table if they have a certain symptom

  • 1.  Checkbox in patient table if they have a certain symptom

    Posted 10-05-2022 11:16
    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
    ------------------------------


  • 2.  RE: Checkbox in patient table if they have a certain symptom

    Posted 10-05-2022 11:21
    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
    ------------------------------