Could I ask for a bit of app/spreadsheet logic help that I’m struggling to get my head around?
I have an app (public with email). The app contains information about different organisations and I only want data pertinent to a specific org to show.
The user logging in could be anyone (I.e. I can’t create a table of users to orgs) so I can’t preempt the user by their email address.
I also can’t just have a dropdown list of the different orgs at first login as I need to keep this information private, and I don’t really want to just show a list of PINs as this would allow users to login as a different org easily.
I’m thinking that I can set and publish a 4 digit PIN by org and then have a screen that prompts new users to type in the 4 digit PIN that they have been sent, and then behind the scenes I am able to relate this PIN to an organisation and then only display the data relating that the correct org.
However I can’t get my head around the logic of how I structure the spreadsheet logic to
1 - validate that the user has entered a valid PIN, and how I relate this back to the visibility of the PIN component
2 - how to use the App: Logins tab to record/use the users PIN for this validation
Afraid I can’t share the app yet as it’s still in development.
Any help appreciated.