When filtering views, you can also create multiple filters to refine the conditions and further narrow down the applicable entries. A distinction is made here between the And link and the Or link.
Due to the large amount of information, you need tools that help you identify what is essential. To work efficiently, you need to be able to filter out irrelevant information so that you can focus on your actual task.
SeaTable is such a tool, because it allows filtering of records, where several filter rules can be linked together. How this linking of conditions works is explained in the article Filtering records in a view.
The ampersand #
With the And link, all specified conditions must apply to a record for it to be displayed.
Here is an example: We are in the view of an editorial plan with numerous articles. First, we have filtered for the topic "Health" in the single selection column named "Subject". We have further narrowed this filter by the second filter, which refers to the exact publication date in the date column. Now we know which of the articles we need to publish on that day.
The or-connection #
In the case of the OR link, the conditions are independent of each other. It is enough if the displayed records fulfill one of the conditions - but they can also fulfill several or all conditions.
Here is an example with single selection columns: Although we can see in the Status column filter for planned articles ("Planned"), completed articles ("Done") and article ideas ("Idea") are also displayed if they meet the second condition of the text type as "Blogpost". In the Type of post column in turn, other text types also go through if the status is "Planned". Even more, scheduled blogposts that meet both conditions also appear in the filtered view.