AnsweredAssumed Answered

Filtered Portal Based on Date Range for Many Records

Question asked by petey on Oct 30, 2017
Latest reply on Nov 5, 2017 by petey



I have the following tables:


Reports (table created for running various reports related to contacts)


Signups (signup records for school dates attended)


I have a Contact portal on the Report layout showing all contacts. On the Reporting layout, I also have two global fields for the start and end date--both are calendar dropdown and are setup as date fields.


I would like to filter the portal by students who attended a school date in that range. I have no SQL experience and was wondering if that was the only way. I know how to do basic relationships where you can use a global field and < or >, but only for one record, not multiple.