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 does filtering work in Zoho Tables?
To begin with, you have to click the Filter option in the view bar of your table. A pop-up window will be displayed asking you to begin applying filter for your views. Click the +ADD CONDITION option. This option lets you add as many conditions as your table may need.
When creating a condition for a filter there are three options involved, they are:
- A drop-down menu that allows you to select the field to apply the filter conditions to
- A drop-down menu with the various condition types
- The final one allows us to enter the value of the condition; you can enter more than one value, which can be a text box/drop-down menu, rating, etc.
Field Type-Based Filtering:
For each field type, there are different types of conditions that you can configure. In the table below we have mentioned every condition, it's usage and the field type it is applicable to.
Condition | Explanation | Field Type Applicable |
filename contains | This filter displays filenames that contain the name you provide in the filter box. For example, if you provide 'John' only file names that contain 'John' in them will be displayed in your field. | attachment |
filename does not contain | This filter displays filenames that do not contain the name you provide in the filter box. For example, if you provide 'Josh' file names that don't contain 'Josh' in them will alone be displayed in your field. | attachment |
filename starts with | This filter displays filenames that begin with the name you provide. For example, if you provide 'Josh' file names that start with 'Josh' will be displayed in your field. | attachment |
filename ends with | This filter displays filenames that end with the name you provide. For example, if you provide 'Josh' file names that end with 'Josh' will be displayed in your field. | attachment |
filetype contains | This filter displays filetypes that contain the requirement you provide. For example, if you provide 'Mary' file names that contain 'Mary' in them will be displayed in your field. | attachment |
filetype doesn't contain | This filter displays filetypes that do not contain the requirement you provide. For example, if you provide 'Mary' files that do contain 'Mary' in them will be alone displayed in your field. | attachment |
filetype starts with | This filter displays the filetypes whose name start with the requirement you provide. For example, if you provide 'Hulk' only file names that start with 'Hulk' will be displayed in your field. | attachment |
filetype ends with | This filter displays filetypes whose name end with the requirement you provide. For example, if you provide 'Hulk' only file names that end with 'Hulk' will be displayed in your field. | attachment |
is empty | This condition displays records that have empty values (empty field values, empty data). | attachment, autonumber, collaborator, created by, created time, currency, date, email, formula, link, lookup, multiselect, modified by, modified time, number, percentage, phone number, rating, rollup, single select, text, URL |
is not empty | This condition displays records that do not have any empty values. | attachment, autonumber, collaborator, created by, created time, currency, date, email, formula, link, lookup, multiselect, modified by, modified time, number, percentage, phone number, rating, rollup, single select, text, URL |
equals(=) | This condition is used to display exact records. If you want to display records that match the exact characters you have provided, use this condition. For example, if you want to display the record 'jhelleker1@netvibes.com' from a list of 1000 records, this filter condition will display that exact records. | autonumber, created time, currency, date, email, formula, link, lookup, modified time, number, percentage, phone number, rating, rollup, text, URL |
not equals (≠) | This condition is used to hide or omit certain records from being displayed. For example, if you have a list of '1000 emails', and want to omit a particular email, say ''ahuske7@unesco.org'' from being displayed, use the Not Equals filter condition. | autonumber, created time, currency, date, email, formula, link, lookup, modified time, number, percentage, phone number, rating, rollup, text, URL |
before(<) | This condition displays values that are before the requirement you provide. For example if you type '8', all the values that are before '8' will be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating, |
after(>) | This condition displays values that are after the requirement you provide. For example if you type '22', all the values that are after '22' will be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating |
on or before(≤) | This condition displays values that are either equal to or before the requirement you provide. For example if you type '22', all the values that are equal to '22' or before '22' will be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating |
on or after(≥) | This condition displays values that are either equal to or after the requirement you provide. For example if you type '22', all the values that are equal to '22' or after '22' will be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating |
between | This condition displays values that are in between the value range you provide. For example if you provide the range as between '2' and '22', all the values that are in between this range will alone be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating |
not between | This condition displays values that are not in between the value range you provide. For example if you provide the range as between '2' and '22', all the values that are not in between this range will be displayed. | autonumber, created time, currency, date, modified time, number, percentage, rating |
today | This condition will display the values that have changed for today alone. For example if you have configured the modified time field and configure this condition, records that were modified today alone will be displayed. | created time, date, modified time |
tomorrow | This condition will display the records that have tomorrow date. | date |
yesterday | This condition will display records related to yesterday. For example if you have configured modified time, and select condition as yesterday, all the records that were modified yesterday will be displayed. | created time, date, modified time |
one week ago | This condition will display records related to one week ago. For example if you have configured created time as the field type, and select condition as one week ago, all the records that were created one week ago will alone be displayed. | created time, date, modified time, |
one week from now | This condition applies to the date field alone. It will display records that have dates configured to one week from the current date. | date |
one month ago | This condition will display records that were either created a month ago, have configured the value exactly a month from the current date or were modified a month ago. | created time, date, modified time |
one month from now | This is applicable for the date field alone. The records that have dates exactly a month after from the current date will alone be displayed. | date |
number of days ago | This condition will display records based on the number of days you provide in the filter box. For example, if you select created time as field type and give the value as 7 in the number of days ago section, the records that were created 7 days ago will be displayed. | created time, date, modified time |
number of days from now | This condition is applicable only for the date field. It will display records based on the number of days from the current date. For example, if you select 7 as the value, the records that have the date 7 days from the current date will alone be displayed. | date |
is selected | Applicable for checkbox field alone. Will display only the selected checkboxes. | checkbox |
is not selected | Applicable for checkbox field alone. Will display the checkboxes that are not selected. | checkbox |
is any of | This condition filters the value based on the name. For example if you have configured modified by field type and select the value as 'John' the records that were modified by 'John' alone will be displayed. | collaborator, created by, modified by, single select |
is none of | This condition filters the value based on the name. For example if you have configured modified by field type and select the value as 'Alex' it omits the records modified by "Alex" and displays the rest of the records. | collaborator, created by, modified by, single select |
contains | This filter condition returns records that contain the value you provide. For example, if you want to display records that contain the value 'John', enter the value 2 in the filter, only the records that consist of the value 'John' will be displayed in the field. | email, formula, link, lookup, phone number, rollup, text, URL, |
does not contain | This does not contain filter will display records that do not contain the value you provide. For example, if you want to display records that do not contain the value 'Shaw', enter the value 'Shaw' in the filter. Records that does not have the value 'Shaw" will be displayed, rest of the records will be displayed. | email, formula, link, lookup, phone number, rollup, text, URL |
starts with | This condition is used to display records that start or begin with a certain value. For example, if you want to display phone numbers that begin with the number '+91', you can use this filter option. You can see that only phone numbers start with number +91 will be displayed in the field. | email, formula, link, lookup, phone number, rollup, text, URL |
ends with | The Ends With condition display records that end with a certain value. For example, if you want to display emails that end with the letter 'a' alone, you can use this filter option. What happens is only email records that end with the letter 'a' will be displayed on the grid. | email, formula, link, lookup, phone number, rollup, text, URL |
has any of | This condition is applicable for multiselect field type. Say for example you have created three options namely 'Apple', 'Orange' 'Lemon'. Now when you select has any of 'Apple' only the records that have the value 'Apple' will be displayed. | multiselect |
has none of | This condition is applicable for multiselect field type. Say for example you have created three options namely 'Apple', 'Orange' 'Lemon'. Now when you select the condition "has none of" 'Orange', the records that do not have 'Orange' in them will alone be displayed. | multiselect |
has all of | This condition is applicable for multiselect field type. Say for example you have created three options namely 'Samsung', 'Onida', and 'Bluestar'. You now choose the condition as "has all of" and value as 'Samsung'. All the records that have selected 'Samsung' will be displayed. | multiselect |
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:
Centralize Knowledge. Transform Learning.
All-in-one knowledge management and training platform for your employees and customers.
New to Zoho Writer?
Create. Review. Publish.
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
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.
New to Zoho Survey?
Zoho Sheet Resources
Zoho Forms Resources
New to Zoho Sign?
Zoho Sign Resources
Sign, Paperless!
New to Zoho TeamInbox?
Zoho TeamInbox Resources
New to Zoho ZeptoMail?
Design. Discuss. Deliver.
New to Zoho Workerly?
New to Zoho Recruit?
New to Zoho CRM?
New to Zoho Projects?
New to Zoho Sprints?
New to Zoho Assist?
New to Bigin?
Related Articles
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 ...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 ...
New to Zoho LandingPage?
Zoho LandingPage Resources