You can setup a set of checks in a script, for example if a person must qualify for at least 4 of these protocols to be listed under that protocol set.
There are several ways to do it that way, would like a few more details.
With a small change in one field, I don't think you need a script, nor a calculation for your portal to work.
Change "age range" to two number fields: MinAge, MaxAge.
Now you can set up this relationship for your portal (I'm just using the fields you explicitly identified, you'll have to add the rest.)
patient info::Current Age > Protocols::MinAge AND
patient info::Current Age < Protocols::MaxAge AND
Patient info::Disease Status = Protocols::Disease Status AND
Patient info::Disease = Protocols::Disease
I'm making some assumptions here that may not apply to reality here. I'm assuming either just one value in Protocols for Disease Status and Disease or that these two fields are formatted as check box fields where multiple values for status and disease can be selected for the same protocol.
Also, Current Age is almost certain to be an unstored calculation (so it can update as time progresses). This will not keep the relationship from working for this portal as fields on the "one" side of a one to many relationship can be unstored or global.
For some of the protocols, there are options of more than one disease status, and moreso, more than 1 disease, referring to:
I'm making some assumptions here that may not apply to reality here. I'm assuming either just one value in Protocols for Disease Status and Disease or that these two fields are formatted as check box fields where multiple values for status and disease can be selected for the same protocol
Therefore, I want to change my data (that have more than one option) to check boxes via the inspector, instead of a drop down menu?
I was thinking each subject would have to fit inside a specific criteria, which could possibly be a number range...which is why I suggested the script sets...just sounds like we need a little calculation here.
i.e. If the patient meets a minimum of 60% of the criteria they are placed into that protocol
@Phil - Brilliant idea you had there! Made me look at it differently...
Checkboxes are my preferred method for managing a list of multiple values in a field. As long as there are multiple values in this field separated by returns and the field can be indexed, this method will work.