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
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
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!
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
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
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
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
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Ahhh thank you Daniela! So I just need to delete the first default filter so manually added filter group becomes the parent filter
makes sense!
Happy to help!