Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Understanding Filter Function Options: AND vs. OR in Tables

·

·

Hey team, trying to utilize filter function to clean out the table but it seems like I can only toggle AND or OR for all filters at once. Is that by design? I'm trying to create 2 filter groups 1 contains 2 input with OR and second group with AND

Understanding Filter Function Options: AND vs. OR in Tables | Clay

10 comments

· Sorted by Oldest

Channeled
APP
·
·
Yes, you can create multiple filter groups with different logic operators. Here's how: 1. Click on the Filters icon in the top menu of your table 2. Click "+ Add filter group" 3. Inside your first group: • Add your two filters using "+ Add filter" • Select "OR" as the group logic 4. Create a second filter group by clicking "+ Add filter group" again • Add your filters • Select "AND" as the group logicYou can layer filter groups up to two levels deep to create these advanced filtering conditions. Source: Customizing your table view | Documentation | Clay University
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Andi Deng
·
·
if that's the case I think there might be a bug. Right now change 1 filter to AND or OR would change all filters logics at once
Bo (Clay)
·
·
To create filter groups with different logic (AND/OR), use the "Add filter group" button first. Each group can have its own logic - so you can have one group using OR and another using AND. From inside each group, you can select the specific logic you want for those filters. Here's two screenshots If you can share your current table url, I can help you structure it correctly to achieve your exact requirements. https://downloads.intercomcdn.com/i/o/w28k1kwz/1321145957/4a17222963b5a150f486a0c4bfaf/CleanShot+2025-01-04+at+_23OdggUl8V%402x.png?expires=1735998300&signature=2189ce2812bdf213ec50605ead85e6b1cde7249bbfc11c45a14de2efcdb8873b&req=dSMlF8h6mIhaXvMW1HO4zYdo%2Btow6o3Fbmm9024CuJV2BGEoXbXcqHh%2FRw75%0A%2Bbb3%0A https://downloads.intercomcdn.com/i/o/w28k1kwz/1321145583/593207e69fd059705c0c2e52258b/CleanShot+2025-01-04+at+_430j4xPwmK%402x.png?expires=1735998300&signature=4454560b9a43c509f49325048c0d57759dcc4a987464d3d5b67333abae4e0054&req=dSMlF8h6mIRXWvMW1HO4zRfQaSz9YsFiymAp51SWl2o3s7ZkPb8cTufm53bZ%0ASnzN%0A
Andi Deng
·
·
Thanks very much Bo! I just tried it again and for some reason the logic operator on my table would all change at once if I try to change any one of them. Here's a quick loom video for your reference: https://www.loom.com/share/cb6a2eb780144c18b4930070fa465e3a
Daniela Debebs (Clay)
·
·
Hey there! Thanks for the reply. Happy to help✨. I made a quick recording below showing how to set this logic in your table. Let me know if this helps! https://downloads.intercomcdn.com/i/o/w28k1kwz/1322950989/5178bfa847480c59361a7bb341a8/CleanShot+2025-01-06+at+14_41_10.gif?expires=1736172900&signature=131d9c2075a5dc33e961be548325e39bb40bdae1e945e0d514a9c7c64f667fa1&req=dSMlFMB7nYhXUPMW1HO4zcJVp9IjveAJj3mVCW7p608a9cgeCpTZXjdV2Fem%0AD2cg%0A
Andi Deng
·
·
Ahhh thank you Daniela! So I just need to delete the first default filter so manually added filter group becomes the parent filter
Andi Deng
·
·
makes sense!
Daniela Debebs (Clay)
·
·
Happy to help!
Channeled
APP
·
·
Hi Andi Deng! This thread was recently closed by our Support team. If you have a moment, please share your feedback: