# Cannot Filter Custom Collection Based on a Computed Column **URL:** \ **Category:** Ask for Help\ **Tags:** custom-code\ **Created:** [May 29, 2025, 12:52pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133 "2025-05-29T12:52:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Patricio\_MK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patricio_mk/32/87587_2.png) [@Patricio\_MK](https://community.glideapps.com/u/Patricio_MK)\ **Post date:** [May 29, 2025, 12:52pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/1 "2025-05-29T12:52:34Z")
Hello, I have a custom collection, with a rich text component inside, that has some HTML. I’m trying to filter based on an IF then Else column, works with a native collection but not with custom ones. I can’t figure this out. is there any limitation for that in glide? thanks ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [May 29, 2025, 1:25pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/2 "2025-05-29T13:25:30Z")
If I understand, you have a standard collection and also a custom collection with both a filter. The standard collection filter works, but not the custom collection filter. Right? May I ask you to show us how you configured your filters? ---
**Author:** ![Patricio\_MK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patricio_mk/32/87587_2.png) [@Patricio\_MK](https://community.glideapps.com/u/Patricio_MK)\ **Post date:** [May 29, 2025, 1:51pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/3 "2025-05-29T13:51:18Z")
Now after troubleshooting, it seems it’s related to row ownership. I have a table listing all cars, that all users have access to, Im querying ongoing and upcoming bookings doing an IF else that will show “available” and “Not available”. for a user with ownership on the Bookings table, the filter works. for a non owner it just displays a fallback value as “Available”. if I look into the table the values are correct, you think there is a workaround to other than removing row ownership and exposing my data? ---
**Author:** ![Patricio\_MK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patricio_mk/32/87587_2.png) [@Patricio\_MK](https://community.glideapps.com/u/Patricio_MK)\ **Post date:** [May 29, 2025, 1:53pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/4 "2025-05-29T13:53:48Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/a/7a912e7be3517a9380c6ff1007e36fa5dab8e453.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/2/c2babfab8197edf9c7751ebb1362360e1301f2e1.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a82f264d1e0b143438094f6fe10293aa9ecc3644.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc3c577321ac4d68a9238beebd69fb55f57fc07e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/20b9188e774bddbe4c1c8836847be5566522c729.png) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 30, 2025, 12:13am UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/5 "2025-05-30T00:13:04Z")
What do you expect the logic to be with the non-owner? I assume that you’re showing a list of available cars, but the bookings that are tied to the car are protected with row owners? ---
**Author:** ![Patricio\_MK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patricio_mk/32/87587_2.png) [@Patricio\_MK](https://community.glideapps.com/u/Patricio_MK)\ **Post date:** [May 30, 2025, 5:32am UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/6 "2025-05-30T05:32:06Z")
Correct. In the data editor all is good. But when it comes to filtering with the obtained data it doesn’t work. Unless I remove the row ownership. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 30, 2025, 10:00am UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/7 "2025-05-30T10:00:22Z")
Is there a way you can have a mirrored table with only the columns you can make public? E.g: The date and the car ID. ---
**Author:** ![Patricio\_MK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/patricio_mk/32/87587_2.png) [@Patricio\_MK](https://community.glideapps.com/u/Patricio_MK)\ **Post date:** [May 30, 2025, 5:28pm UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/8 "2025-05-30T17:28:02Z")
Im not sure. How can i do that ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 31, 2025, 1:26am UTC](https://community.glideapps.com/t/cannot-filter-custom-collection-based-on-a-computed-column/82133/9 "2025-05-31T01:26:32Z")
When you add a new booking, add a row with basic columns in the “mirrored” table, alongside the rowID of the original booking row. Establish a relation between the original and the mirrored row. When you edit a booking, edit the mirrored row as well. Same as delete. The idea is you will store only info that are not identifiable or public-able in that table, and keep the rest of the info private via row owners in the bookings table.