Filtering on an entered value

Ask for Help
1

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

2

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?

3

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

4

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”.

5

Thank you
With some approximations it worked )

Thank you very much
:green_heart:

6

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).