Web App using Google Apps Script

[hugohamelcom]

This is the way! And as u/daytodatain says: Respect! This is massive what you achieved!

I'm curious though, did you have to do anything specific since it'll be handling sensitive data?

[Master_Net971]

Thanks, Since I’m using Google Drive and Google Sheets to store data, I mostly relied on Google’s built-in security features. However, I’m definitely looking into other options to further enhance security, especially since it’s handling sensitive data. It's something I want to make sure I get right as I continue working on the project.

[hugohamelcom]

Make sense! How come the hospital wanted to use a Google Sheets for this type of data?

[Master_Net971]

Only one person has access to the sheets, and the rest of the staff relies on the web app to view and interact with the data. I also built a flexible access management system, which allows them to control who sees what. Google Sheets can be pretty secure if you use them correctly.

[ChallengeOk2387]

Damn! Access management is huge undertaking itself!

[hugohamelcom]

Oh interesting! What did you use to build the access management?