A couple of observations coming from Bubble. I love how Glide can generate an attractive UI with very little effort. Requires a lot of work in Bubble. But adding advanced filter and sort logic to a Glide app is much harder than Bubble. Some comments/suggestions:
Custom filters and sorts would be much easier if Glide supported current-user-specific (inc. anon users) screen variables that could be used to filter and/or sort a screen list.
Currently, I have to store screen filter selections in the user sheet. This creates complexity and makes it very hard to support a UI that works for both signed-in users and anon users.
Filters would also be easier if we could combine ANDs and ORs in list filter logic instead having to recreate boolean logic via multiple helper columns in a sheet.