Hi there,
It seems that Google Script web application will be the right option for your case. First of all, regarding security, the web app will be only accessible for users within your G suite domain, just like when you share a document to users within your domain. In addition, we can limit access to only specific users within your domain.
Here's an inventory management web app developed for a client who manages a pharmacy here:
[login to view URL]
So your project will be similar to that one. We will have two tabs initially, one to enter a new log entry "we won't need to use the form anymore!". The other tab will be to view the logs in a neat way.!
First, you will have an autocomplete search bar to view the logs of a specific minor. If the search bar is clear, it will show the logs for all minors "check the transactions tab in the attached app".
Second, you will be able to filter the logs based on date range to view the logs in a specific interval using start and end date.
Lastly, you can filter the logs based on the rating.
The app will use Google spreadsheet is save the data. However, the users "except for the administrator" won't have any access to the spreadsheet. They can enter the data or view the logs using the app, but once the log is entered, it can't be changed unless the spreadsheet owner edits it.
I will be happy to address any of your questions!
Sincerely,
Mohamed