# Filtering on an entered value **URL:** \ **Category:** Ask for Help\ **Created:** [January 25, 2026, 9:01pm UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139 "2026-01-25T21:01:41Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![DianaT](https://avatars.discourse-cdn.com/v4/letter/d/e95f7d/32.png) [@DianaT](https://community.glideapps.com/u/DianaT)\ **Post date:** [January 25, 2026, 9:01pm UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/1 "2026-01-25T21:01:41Z")
Hello I have a table of events. At the event creation, user enters an AccesCode that is stored in the table. People can respond to an event. The responses are stored in EventResponses table and I populate each row with the corresponding AccessCode value from the event. The idea is that the Event creator can access all the responses via the AccessCode. I create a separate Custom screen to enter the EnteredAccessCode. The idea is to show the responses that have the equivalent AccessCode. I tried everything - from storing the EnteredAccessCode into a field in Responses. I tried to created a dedicated SessionInfo table and populate it with entered code and create a relation with all the fitting responses: Nothing seem to work correctly Im totally stuck ) I did not get the feel of Glide yet)) I do not have any user login yet. Its an MVP Thanks for help Diana ---
**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:** [January 26, 2026, 1:11am UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/2 "2026-01-26T01:11:39Z")
So it’s an app where an admin can create events, people can create responses for those events but those are locked with a “passcode” on the event level. Any admin can go in a screen, type a passcode to show all responses to that event. Is that correct? ---
**Author:** ![DianaT](https://avatars.discourse-cdn.com/v4/letter/d/e95f7d/32.png) [@DianaT](https://community.glideapps.com/u/DianaT)\ **Post date:** [January 26, 2026, 7:49am UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/3 "2026-01-26T07:49:41Z")
No Its a totally open environment - anyone can create an event, anyone can view any event, anyone can respond to any event BUT only the person who created the event can access the responses. So, i introduced the AccessCode When you create an event - you add a secret AccessCode and then scenario goes as I described in the initial post D ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [January 26, 2026, 8:34am UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/4 "2026-01-26T08:34:50Z")
How about trying the following: 1. Create a one-row helper table (source of the Event Responses custom screen) 2. In that table, create a user-specific text column “Event Access Code” (bound to a text entry component in the Event Responses screen) 3. Create a query column querying the responses table with the filter “access code is this row access code”. This should return a subset of the responses table based on the access code. (source of the responses collection component on the Event Responses screen). 4. Optional: Clean up the collection component as needed by removing the title bar action, perhaps removing the title, perhaps adding a visibility condition “Event Access Code is not empty”. ---
**Author:** ![DianaT](https://avatars.discourse-cdn.com/v4/letter/d/e95f7d/32.png) [@DianaT](https://community.glideapps.com/u/DianaT)\ **Post date:** [January 26, 2026, 9:09am UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/5 "2026-01-26T09:09:54Z")
Thank you With some approximations it worked ) Thank you very much 💚 ---
**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:** [January 27, 2026, 2:46pm UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/6 "2026-01-27T14:46:50Z")
If these people do have to sign in, you don’t need an access code at all. You can just have a collection of responses and show that in the details screen, visible only to the event’s creator (whose ID you collect when the event is created). ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [February 3, 2026, 2:47pm UTC](https://community.glideapps.com/t/filtering-on-an-entered-value/86139/7 "2026-02-03T14:47:48Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.