# How to build a custom advanced search filters? **URL:** \ **Category:** Ask for Help\ **Created:** [August 17, 2022, 11:06pm UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061 "2022-08-17T23:06:35Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Brice](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@Brice](https://community.glideapps.com/u/Brice)\ **Post date:** [August 17, 2022, 11:06pm UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/1 "2022-08-17T23:06:35Z")
Hello! As you know, updates based pricing affected the way we allow the users to filter items. We can use user specific column to build custom advanced filters using choice component. Now, every time the user changes a value, Glide counts as an update. For a listing or directory app, a user can make multiple updates a day. What happens if the app got thousands of users per day? As Glide hasn’t an advanced search filters, HOW ARE YOU DOING NOW? ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [August 18, 2022, 1:03am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/2 "2022-08-18T01:03:12Z")
Agreed. Another reason why (in my opinion) User Specific Columns shouldn’t count towards updates. @DJP ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [August 18, 2022, 3:38am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/3 "2022-08-18T03:38:40Z")
Totally agree as well!! Count edits generated by USC is a nightmare to create a smart and efficient UX 🤬 ---
**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:** [August 18, 2022, 3:55am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/4 "2022-08-18T03:55:08Z")
Vote! > [@Session Variable Column](https://community.glideapps.com/t/session-variable-column/40260): > > I’ve always thought that it’s really useful how user specific columns only store values locally and for the duration of your session while you are not signed in. This allows for those column values to “reset” after you close the app, and the data does not need to be sent and synchronized with glide servers. However, once you sign in, then those values are sent to, and stored, on Glide’s servers. I think a new Session column type could be really useful. It would work just like user specific c… ---
**Author:** ![orth](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/orth/32/29029_2.png) [@orth](https://community.glideapps.com/u/orth)\ **Post date:** [August 18, 2022, 4:06am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/5 "2022-08-18T04:06:47Z")
Yah, some type of ‘local variables’ strongly needed ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [August 18, 2022, 5:24am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/6 "2022-08-18T05:24:14Z")
I have an App ( a business listing App) that is built around this concept of using filters. The App is on starter plan and thus far I have not gone live with it because I keep expecting that Glide will do something about this which means I am paying $25 a month for nothing thus far. I have seriously gotten to a point of considering other alternatives for this particular use case until Glide finds a workable & more affordable solution. I don’t think App owners/creators should be “penalized” for lack of functionality or features and this is what it feels like to be honest. These filters using USC’s are “work-arounds” that creators have had to come up with ONLY because there is no “proper” native way to filter and App creators should not have to pay for that in my opinion. This is where this updates explanation starts to be inconsistent because if you charge because of the changes being synced with Glide servers fair enough but I would love to know how that holds up for USC because the changes are not being synced with the servers but rather are done locally on the device unless I missed something about this whole thing. ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [August 18, 2022, 5:34am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/7 "2022-08-18T05:34:15Z")
I thought you would have got a DM from @DJP as to what they plan to do with this REAL concern if anything is done at all… > [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932/163): > > I’ll shoot you a DM to discuss further ---
**Author:** ![Purvang\_Joshi](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/purvang_joshi/32/12645_2.png) [@Purvang\_Joshi](https://community.glideapps.com/u/Purvang_Joshi)\ **Post date:** [August 18, 2022, 6:42am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/8 "2022-08-18T06:42:40Z")
Use all components in Edit Screen option. All changes will count as 1 update when you’re using edit item. ---
**Author:** ![Brice](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@Brice](https://community.glideapps.com/u/Brice)\ **Post date:** [August 18, 2022, 7:07am UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/9 "2022-08-18T07:07:42Z")
I think you don’t understand. The edit screen can’t be used. It’s not for editing datas, but use user specific columns to create search filters. It must be done only on details screen. ---
**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:** [August 18, 2022, 12:16pm UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/10 "2022-08-18T12:16:52Z")
> [@Luther](#): > > if you charge because of the changes being synced with Glide servers fair enough but I would love to know how that holds up for USC because the changes are not being synced with the servers but rather are done locally on the device But, USC columns actually are synced to the server. They are stored internally in Glide’s database. They are not stored locally on the device. There is a gray area if the user is not signed in, but it’s my understanding that even if a user is not signed in, the USC columns are still communicating with the database, so it still causes updates. Think of USC columns like an invisible table that contains a Row ID, Email, and the stored Value. When you create a USC column, glide is essentially creating a sort of relation to this invisible table, using RowID and Email as the key, and creating a lookup to return that value specific to a user. But it’s all packaged up nicely as a simple USC column instead of having to create extra tables, multiple computed columns, and set column actions to set the value. If you export your data sometime, I believe you will see all of that USC data as a separate table in the export. So, I think the problem for glide right now is that USC columns DO cause updates just like any other column that stores a value. Someone could really exploit that loophole if glide allowed updates to ignore USC columns. Someone would try to circumvent updates to store all permanent data in USC columns intead if only custom filters or custom form data. Long story short, and to answer your question…USC columns are still just basic columns that store values in Glide’s database. They just work a little differently in where they are stored in that database and how they are retrieved and displayed. Glide has mentioned that they should build more functionality for filtering, but I still think something like a session variable, or a value that’s always only local to the device, would provide the best flexibility in the long term. ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [August 18, 2022, 4:19pm UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/11 "2022-08-18T16:19:51Z")
Thanks for taking the time to explain Jeff. Much appreciated… If I had the ear of those in power, I would advise them to temporarily not count changes on USC as updates as that kinda highlights the need for a better filter… Most Glide developers overlooked that short coming because of the work-around using USC… but with that now not being as useful, it places a demand on the team to work on a better filter… But I have faith in them that they will come up with an acceptable solution soon ---
**Author:** ![Brice](https://avatars.discourse-cdn.com/v4/letter/b/a3d4f5/32.png) [@Brice](https://community.glideapps.com/u/Brice)\ **Post date:** [August 18, 2022, 8:31pm UTC](https://community.glideapps.com/t/how-to-build-a-custom-advanced-search-filters/47061/12 "2022-08-18T20:31:36Z")
And when I think about limitation causes by updates price based, Glide becomes not suitable for serious and valuable apps. Another example, I’ve in one app a feature to count and display visits and visitors on items using increment function, that means thousands of updates per day. 😥