How do I write the filtering calculation if I want my portal to only show records within a certain event date range?
Events to show should be between 11/1/2016 and 2/4/2017. Do I use an "if" statement? Not sure where to put the greater than or less than symbols.
Thanks.
Thanks! Works great!
How do I count the filtered records. My summary field is counting the total
records in the portal....which is fine for the tab that shows all, but I
need a count of just what is shown in the filtered portal.
-Jane
I think I found the answer online:
Duplicate the portal, have only one line; put the count field on that line.
Works!
A child::summary field on a Parent layout will give you the total records in the child table, not for the portal.
See if this article helps:
This trick works for filtered or non filtered. The key is to have the child::summary field inside a portal row. The "trick" is the single row portal to show this once. (and the two portals have the same: relationship, sorts, & filters.
Beverly
Hi,
In your portal filter calculation you can use this fomula :
Fielddate ≥ Date (11 ; 1 ; 2016 ) AND FieldDate ≤ Date ( 2 ; 4 ; 2017 )