# Show my Favorites
**URL:** https://community.glideapps.com/t/show-my-favorites/74274
**Category:** Ask for Help
**Created:** [June 20, 2024, 5:54pm UTC](https://community.glideapps.com/t/show-my-favorites/74274 "2024-06-20T17:54:30Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@rheims](https://community.glideapps.com/u/rheims)
#### Post date: [June 20, 2024, 5:54pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/1 "2024-06-20T17:54:30Z")
I am making a expense app. All expenses need to be tied to a Project. I have a project list with a Favorite column so users can Favorite the projects they work on most.
In the Add New Expense page I want to add a Choice button to display either My Favorite Projects OR All Projects so the user can click the button. I have this button writing to field called Show Favorites in the Expense table.
When I turn on the Favorites I would like to filter to the Project list where Favorite is checked. This works but when I turn Favorites off the entire Project Number choice list disappears from my Add Screen.
How can I make this behavior work?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 20, 2024, 6:22pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/2 "2024-06-20T18:22:43Z")
Can you show how you have the filter set up?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 21, 2024, 12:05am UTC](https://community.glideapps.com/t/show-my-favorites/74274/3 "2024-06-21T00:05:59Z")
> [@rheims](#):
>
> In the Add New Expense page
You mention this, it looks like it’s a form, so are you actually needing to filter the projects inside a form, or not?
---
### Author:  [@rheims](https://community.glideapps.com/u/rheims)
#### Post date: [June 21, 2024, 12:25pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/4 "2024-06-21T12:25:59Z")
Yes I am trying to filter inside a form.
I added a “Show Favorites” Switch to the form. This changes the "Show Favorites’ field. I am hoping to filter the “Projects” Choice field to only those with a Favorite checked in the project list when switched on. This does work but when I switch the “Show Favorites” off the entire Projects Choice field disappears.
Show Favorites toggled on…
m.
Show Favorites toggled off…
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 21, 2024, 7:12pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/5 "2024-06-21T19:12:50Z")
Booleans can have 3 states. True, False, and blank. In your project table, create an IF column that checks if the favorite column is checked. If it is, return ‘true’, else return ‘false’. Then change your filter to check against the IF column instead of the Favorite column. I’m not sure if that will completely fix the issue, but might help us to debug and point us in the right direction.
---
### Author:  [@rheims](https://community.glideapps.com/u/rheims)
#### Post date: [June 21, 2024, 7:55pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/6 "2024-06-21T19:55:30Z")
Thanks Jeff, That worked!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [June 28, 2024, 7:56pm UTC](https://community.glideapps.com/t/show-my-favorites/74274/7 "2024-06-28T19:56:28Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.