In my Glide Tables I have compiled data of 120 residents in our retirement home and made some computations too. Now when I share the app, I want each individual to login with their unique Apartment Number. They do not have e-mail IDs currently. In due course if that is absolutely necessary for security reasons we can persuade them to create e-mail IDs. In the meanwhile I just them to enter their Aot Number and a matching unique password to login and either edit or view their data.
If you want users to see and edit their own data, you will need to use row owners.
And for that you need to add their email address since it requires a real login.
1 Like
Building your own authentication is not secure and not recommended. That means your app is public and anybody in the world can get into the app and snoop the data. Your authentication requires all apartment numbers and passwords to be downloaded to the device before it can even “authenticate” a user. That also includes any other personal data for the users in any of the other tables. Filters and visibility are not security features.
If you want to restrict who can sign into the app and gain access to any data, you would need to make your app private and what each user.
If you further want to protect data so your users couldn’t possibly snoop data of any other user, then that’s when you need to consider row owners.
With that said, a tab linked to a single row table with user specific columns is an easy way to allow each user to enter their authentication info, and then you can create relations to their respective row data in other table. If users aren’t truly signed in with real authentication, then the values in the user specific columns will clear out when the app is closed. Like I said, it’s not secure by any means, but it answers your question.
4 Likes
Thank you for your detailed response.
Actually I want to first demo this app to our residents, most of whom do not have emails. Once this app is demonstrated and accepted, I will be able to persuade each one to create an email ID. So, during the testing phase we don’t mind compromising on security as there is nothing so sensitive in it, just names, apartment numbers and their preferences for meals. Not even their phone numbers. Even otherwise phone numbers are available to all and sundry because we often get calls from salespeople and spammers.
I hope my point is clear.
Thanks and Regards,
Ninan Joseph
1 Like
I have created a Password test template that would work with the room numbers. As said above it is not secure, but for your specific use case with residents in a retirement home it would work. Users must login first before seeing their specific data.
I’ve even built an assisted living template that could use this approach for residents to view their information and fill out forms.
I’m delighted to hear that you’ve created a template that aligns perfectly with my needs and that you’ve also developed an assisted living template. I’m glad to have found someone who understands my requirements so well.
Could you please let me know the cost of sharing the template with me?
Thank you and best regards,
Ninan Joseph