# In-App filter doesn't work for booleans generated by formula **URL:** \ **Category:** Report a Bug\ **Created:** [July 20, 2023, 11:17am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162 "2023-07-20T11:17:39Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Dvir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dvir/32/50196_2.png) [@Dvir](https://community.glideapps.com/u/Dvir)\ **Post date:** [July 20, 2023, 11:17am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/1 "2023-07-20T11:17:39Z")
**My App/Pages support link:** - It’s in a personal app so it won’t let me generate a link, but this happened to me in every single project. **Describe the bug:** - When using In-App filter in a collection, boolean columns that are a result of a formula (e.g. if then else) always show an empty list when turned on. “Normal” boolean columns work as expected. **Expected behavior:** - When turned on, I expect filters based on formula to show “true” values. **How to replicate:** - Create a table, add an if then else column with any random rule, then try to use it as an in-app filter. **Link to demo recording (optional):** > **[Screen Recording 2023-07-20 at 14.14.24.mov](https://drive.google.com/file/d/14UBXovgTHw1iR-c3xhWfgJeMgdENt6br/view?usp=sharing)** > > Google Drive file. ---
**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:** [July 21, 2023, 12:55am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/2 "2023-07-21T00:55:19Z")
I can confirm this. Please submit a ticket. > [@How to open a support ticket?](https://community.glideapps.com/t/how-to-open-a-support-ticket/59883/2): > > Please note: the option to create a support ticket is only available if your App is in a Pro, Business or Enterprise Team. If you need help with a Billing Issue (on any plan), you should open a Billing Enquiry via the [Glide Support Page](https://www.glideapps.com/support). To create a Support Ticket: Open the App that is giving you problems, and go to Settings → Contact Support: Glide will prompt you to create a support link for your App. Click on Create Link: ---
**Author:** ![Dvir](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dvir/32/50196_2.png) [@Dvir](https://community.glideapps.com/u/Dvir)\ **Post date:** [July 23, 2023, 7:21am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/3 "2023-07-23T07:21:43Z")
Done. Thanks ---
**Author:** ![Maxime\_Binet](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maxime_binet/32/40811_2.png) [@Maxime\_Binet](https://community.glideapps.com/u/Maxime_Binet)\ **Post date:** [July 25, 2023, 2:28am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/4 "2023-07-25T02:28:09Z")
Same problem here, I’m available to help if needed. ---
**Author:** ![Itai\_Peer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/itai_peer/32/75705_2.png) [@Itai\_Peer](https://community.glideapps.com/u/Itai_Peer)\ **Post date:** [July 21, 2024, 1:32pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/5 "2024-07-21T13:32:16Z")
Was this solved? do you mind sharing the solution? I’m having the same issue… Thanks! ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [July 27, 2024, 10:56pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/7 "2024-07-27T22:56:22Z")
i see same problem. addition: single value - does not recognise as empty. it behaviour like it not exist: it’s not affect if choice “empty” or “not empty” ---
**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:** [July 27, 2024, 11:52pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/8 "2024-07-27T23:52:39Z")
> [@user19](#): > > addition: single value - does not recognise as empty. it behaviour like it not exist: it’s not affect if choice “empty” or “not empty” Can you show us the behaviour in a video or some screenshots? ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [July 28, 2024, 10:32am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/9 "2024-07-28T10:32:40Z")
https://www.loom.com/embed/fa78b8474def4b119ac9641c06518f24?sid=2ba3882d-f6e6-4cf2-9606-15502a4c3c76 ---
**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:** [July 28, 2024, 12:39pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/10 "2024-07-28T12:39:41Z")
What row is your tab built on? Do you have any filters on the tab level? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [July 28, 2024, 1:39pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/11 "2024-07-28T13:39:22Z")
Remove this. ![Screenshot_20240728-083707~2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/ff910b5fa9587900be99b48bbea8bc8107d949bb.png) ---
**Author:** ![user19](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/user19/32/52319_2.png) [@user19](https://community.glideapps.com/u/user19)\ **Post date:** [July 28, 2024, 5:17pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/12 "2024-07-28T17:17:58Z")
oh… this time i’m so much wrong… sorry ---
**Author:** ![Shlomo\_Green1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shlomo_green1/32/85661_2.png) [@Shlomo\_Green1](https://community.glideapps.com/u/Shlomo_Green1)\ **Post date:** [February 25, 2025, 2:34pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/13 "2025-02-25T14:34:19Z")
Found a solution! when i use lowercase for the boolean options “true/false” instead of uppercase “True/False” it works ---
**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:** [February 26, 2025, 12:28am UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/14 "2025-02-26T00:28:09Z")
That’s just weird. However, I hardly ever use booleans for filters anymore. I think there are 3 states that can be presented: - No filters - False - True However as I understand it, there’s no way to know if it’s “no filters” or “false”. Is that still correct? ---
**Author:** ![Shlomo\_Green1](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shlomo_green1/32/85661_2.png) [@Shlomo\_Green1](https://community.glideapps.com/u/Shlomo_Green1)\ **Post date:** [February 26, 2025, 7:34pm UTC](https://community.glideapps.com/t/in-app-filter-doesnt-work-for-booleans-generated-by-formula/64162/15 "2025-02-26T19:34:39Z")
I believe that’s correct. I find Booleans to be an effective filter when you are only interested in “true” conditions