Dynamic Filter
Say goodbye to a static data model that doesn't get automatically updated with time. Keep your data alive using the all-new Dynamic Filter!
The Dynamic Filtering option in Zoho Tables filters out records intelligently based on "who views it and when it's viewed."
Who views it: if you wish to quickly view all the records in your name, you can do so in a few clicks.
When you view it: To view all the records that are of today's date, you can directly select the filter option - Today. Each day, the records get updated based on the current date.
Set up your dynamic filters just once and see how your information changes on its own
Currently, we have two types of Dynamic Filters in Zoho Tables. They are:
- Collaborator Dynamic Filter
- Date Dynamic Filter
1. Collaborator Dynamic Filter
- Collaborator
- Created by
- Modified by
It offers 4 different Filter Conditions as follows:
Let's look into a Collaborator Dynamic Filter use case to understand these filter conditions better.
2. Date Dynamic Filter
The Date Dynamic Filter is available for the following field types:
- Date
- Created Time
- Modified Time
It offers 19 Filter Conditions as follows:
Let's consider the present date as 1 Aug 2022
In the above use case, we used an award-giving ceremony base. The date dynamic filter is applied to the Announcement Date field (Date field type), which shows us records based on the filter condition we choose.
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Filter
You can now avoid scrolling through an extensive data set to find specific information, and directly access relevant records using the Filter option. By using Zoho Tables Filter, you can view only the information relevant to your decision-making. How ...Zoho Tables: Customizing your base
Filter Access only relevant records by applying the filter option to your records. To apply a filter, follow the steps below. To create a new filter condition: Tap the Options icon on the right. Choose the Filter option. From the list of fields ...Importing a table from Zoho CRM
Importing from Zoho CRM lets you bring your existing CRM data directly into Zoho Tables as a new base, so you can pick up right where you left off. When fields are imported, they're automatically matched to the appropriate field types in Zoho Tables, ...Duplicating cards in Reports
Duplicating a card lets you quickly create a copy of an existing card in a report, preserving all its configurations — so you don't have to rebuild it from scratch. This is useful when you want to create a variation of an existing card with minor ...The basics of importing a table
When you choose to import a table, all your data is read and automatically categorized into fields. Before you complete the import, you can preview and adjust everything using a range of customization options, so your table is exactly how you need it ...