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:
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 ...Link Field
Connecting Data Across Different Tables Made Easy with Linked Records Say Goodbye to manually entering updates across multiple work-stream. Using Zoho Tables link records, discover the dynamic relationship between your tables with no more duplication ...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 ...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 ...Using Filters During Zoho CRM Import to Zoho Tables
When importing data from Zoho CRM to Zoho Tables, you can apply filters to selectively import records based on specific criteria, helping you import only the data you need. How Filters Work Filters are applied to the fields in Zoho CRM, and only ...