List And Table View
Getting the most out of List and Table view in the Calendar
The calendar’s list and table views behave a little differently from those in the contacts and projects components.
You can arrive at list view by clicking on the list icon in the calendar header (the icons to the right of the back and fwd buttons).
Note that clicking on this will bring up a found set matching the view you were looking at: if you click on the list icon from the day view you’ll arrive at a found set matching the records for that day and respecting any filters that might be in place. Clicking on the list icon from the month view would bring up appointments starting that month.
Note that only items starting or ending in the month, week, etc. show up when you jump to list or table view. Items “spanning” the week or month aren’t automatically included in your found set: to include those you’ll need to search for them.
Once in the list view you can refine your found set by performing additional finds. You can use any of FileMaker’s search functions at this point and if you aren’t familiar with these I’d suggest searching FileMaker’s built in help for “Extend Found Set” and “Constrain Found Set” as these are very helpful commands.
Once you have the found set you’re interested in, the print button at the bottom of the list screen offers the most useful of the calendar’s printing options. Feel free to duplicate and modify the layout we use for this (“Print – Appointments”) to create additional reports.
You can also switch between list and table view by clicking on the table view icon to the right of the list icon. Table view offers you some additional options.
Export to Excel
First, you can export to Excel from table view—since FileMaker’s export routine takes all the fields on the layout, its nice to do this from table view where there are no interface or extraneous fields present. To include new fields in this export, simply add them to the table view layout.
Export to iCal
You can also export the found set to iCal from table view. See Import or Export ICal for more information.
