# Filtering Inline on empty values (user specific) **URL:** \ **Category:** Ask for Help\ **Created:** [May 18, 2024, 8:37am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475 "2024-05-18T08:37:03Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\ **Post date:** [May 18, 2024, 8:37am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/1 "2024-05-18T08:37:03Z")
Hi, I have an SQL table on an inline collection. I would like to filter the collection if RESOURCENAME is empty or not AND CHECKINDATE is today and save these selections to the User Table. I have the CHECKINDATE part working, but cant figure out how to add RESOURCENAME is empty or not. I was trying to do an If…then in another column (true or false), as RESOURCENAME can be any value, but you cannot filter by the If…Then column, only columns in the SQL table. Any ideas? ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [May 18, 2024, 10:31am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/2 "2024-05-18T10:31:21Z")
Would it help if you added another column to the SQL table solely for filtering in Glide? ---
**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\ **Post date:** [May 18, 2024, 10:47am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/3 "2024-05-18T10:47:01Z")
Thanks for your reply Eric. Are you suggesting adding another column outside of Glide and then using that for filtering in Glide? Or would this possible just adding another column in Glide and doing some sort of computation? ---
**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 18, 2024, 11:51pm UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/4 "2024-05-18T23:51:36Z")
I don’t have any experience with using SQL. If your resource name and check in date columns are not computed columns, wouldn’t you be able to use them in the collection’s filter itself opposed to doing it with an if-then-else column? As far as I aware, filtering is only limited for computed columns, not “basic” columns that you import from SQL. ---
**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\ **Post date:** [May 20, 2024, 6:39am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/5 "2024-05-20T06:39:15Z")
Thanks ThinhDinh. Say I have a table with a RESOURCENAME which contains 100s of rows with some unknown value and other rows without a value. I was hoping I could save some value in the User Table which would give the option to the user to filter the RESOURCENAME by if its empty or not (giving both options). Do you know if this possible? I presume the collection filter would have to be _RESOURCENAME includes XXXX_, with me working out all the distinct RESOURCENAME values as XXXX and saving this in the user table. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28b8af138548bce6ca05f2ec19a6e0e9a67a1683.png) ---
**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:** [May 20, 2024, 11:40am UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/6 "2024-05-20T11:40:10Z")
> [@pills101](#): > > I presume the collection filter would have to be _RESOURCENAME includes XXXX_, with me working out all the distinct RESOURCENAME values as XXXX and saving this in the user table. Wouldn’t it be easier to set the filter to check for empty or not empty? ---
**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\ **Post date:** [May 20, 2024, 2:57pm UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/7 "2024-05-20T14:57:14Z")
How do you do that as a user option? I can set it to empty or not empty in the design, but I how do you allow the end user to filter by either option? ---
**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 20, 2024, 3:04pm UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/8 "2024-05-20T15:04:14Z")
So you want them to filter by the “Resource name” being empty or not? As SQL data sources don’t allow filtering by computed columns, I think you can just have: - A choice component that writes a choice to a user-specific column (“Has resource” and “Doesn’t have resource”). - Show a collection filtered by resource name is not empty, when the user choose “Has resource”, and vice-versa. ---
**Author:** ![pills101](https://avatars.discourse-cdn.com/v4/letter/p/ecae2f/32.png) [@pills101](https://community.glideapps.com/u/pills101)\ **Post date:** [May 20, 2024, 3:13pm UTC](https://community.glideapps.com/t/filtering-inline-on-empty-values-user-specific/73475/9 "2024-05-20T15:13:33Z")
Ok, so use the visibility condition to show/hide either collection based on the user-specific column. Thanks, I will give that a go.