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------------------------------
Original Message:
Sent: 10-05-2022 11:15
From: Solace Sonder
Subject: 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
------------------------------