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

Hello,

 

I have the following tables:

 

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

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.

 

Thanks,

Pete

Outcomes