I have a simple app which has a set of rows of information with columns such as Year, Subject. For each Year and Subject, there are specific classes with their times.
I have configured the layout such that when a user makes two choices, one for year and one for subject, the rows for that year and subject will be shown.
It works fine when I do it. But, since I dont want it to be a public with email app, but just a public app, is it possible for multiple users to do the selection of year and subject and get their own specific results.
I have a Users sheet, but since it is public, every user will only see the first row. So, how can each user make selections of Year and Subject of their own?
I dont want to make it public by email, since I don’t have any use for email login. It is just a simple search functionality.
The app is at https://classcodes.glideapp.io