So if you have an event date of 6/1/2014 (MMDDYYYY), you want the dates for 6/2/2014, 6/3/2014, 6/4/2014 and 5/31/2014, 5/30/2047 and 5/29/14?
This portal filter could list all related records with such dates in a single portal:
LayoutTable::EventDate - 3 < PortalTable::Date And LayoutTable::EventDate + 3 > PortalTable::Date
This can also be set up with no portal filter expression if you have a match field of the 7 dates, each separated by a return as one of the match field pairs of fields in your relationship.
I see, I'm trying to get the three dates either side to show in separate columns though. If you think of it as a five day scrollable window, so you'd see the control date in the center and then the three dates either side.
I run a small hostal, so the date portals contain guest names, room numbers and checkout dates. So I can see at any given date who is here and if they were here the days before and after the given control date.
I've been drawn to the examples of people setting up calendars with Global variables instead of the Global fields, but I'm just learning and am having problems filtering the portals to the variables.
Then you can set up one row portals, each with either a different relationship or a different portal filter to get your columns of information.
The filter expressions might look like this:
LayoutTable::EventDate - 3 = PortalTable::Date
LayoutTable::EventDate - 2 = PortalTable::Date
LayoutTable::EventDate - 1 = PortalTable::Date
LayoutTable::EventDate = PortalTable::Date
LayoutTable::EventDate + 1 = PortalTable::Date
LayoutTable::EventDate + 2 = PortalTable::Date
LayoutTable::EventDate + 3 = PortalTable::Date
Where each row above is a filter for a different portal.
Thank you thank you!!
Filemaker is new to me and while so very intuitive, there's some things I'm struggling to grasp.
Thank you for your help, you've ended days of frustrated hair pulling!