Filters are a set of named criteria that allows you to select only specific entries in a report. Zoho Creator creates default filters for the fields belonging to any of the following types. These filters are called "Auto filters".
If your form contains any of the above field types, the corresponding field names will be displayed in the GUI as shown below, when you select the Set Filters option for a report in Edit mode. For example, in the Employee details form, the field Department is a single-select picklist field. Hence, it is displayed as a default filter. You can enable/disable the auto filters using the show/Hide button. By default, it is disabled.
When you access the report, the filters will be displayed in the Filter list-box as shown below. The name of the field will be taken as the name of the filter. The values for the fields will get displayed in the Filters drop down list. Selecting a filter name, will display only those records that satisfy the filter criteria. For example, if the Department is selected as "Accounts", only those employees in the Accounts department will be listed.
Custom filters are a set of named criteria that can be defined by the user. To create a custom filter,
Lets say we need to fetch records of last few weeks from a Zoho Creator Report. For example, records from last 6 to 12 weeks. This can be achieved by adding a custom filter based on the subWeek() function. To add the filter,
The configured custom filter fetches and displays records from the last 6 to 12 weeks.