I have a calendar with dates from two tables. It looks like the filters on the calendar layout need to be tied to one table or the other. Is it possible to filter both tables at the same time if the both sources are selected?

Hi,

You are correct that the calendar only supports the filters for Source No 1 "out of the box," but it can be modified to apply the filters to multiple sources as well. Basically, the script:

"Load Calendar Settings - On Startup --- Edit Configuration Here ---"

sets the filter fields including the table they belong to, i.e. SampleEvents. You could store the field names without the table occurrence, i.e. store "Summary" rather than "SampleEvents::Summary." Then when the filters are applied in the script:

"Apply Filter to Found Set"

You could add the context back in based on the context of the source, i.e.

Set Field By Name [Evaluate ( "Get ( LayoutTableName ) & \"::\" & $$sc_filterfield" & $sc_FilterNumber )

when setting up the find requests.

This is moving into somewhat advanced development, so please feel free to contact me at [email protected] if you might need some additional assistance with this.

Hope this helps and Best Regards,
-Jason