Looking to create an app that we can have our students use to sign in and out of their classes for the restroom. Ideally, students would scan their ID, the app would retrieve their name from their ID (via their ID Number), students would select the class they are in, and if they are leaving class or returning. The app would show who last signed in/out for the teacher to verify that the student signed in/out.
Last year I created one that used a Google Form for collecting the data. The sheet was programmed to pull the student name based on the ID number that was scanned. The problem was that if everything was not filled out properly, the app would look like it submitted, but it would not record into the Google Sheet. I was hoping to eliminate the Google Form aspect of the app but not sure how/what to use as a database.
Any ideas or suggestions on how to go about creating this app would be greatly appreciated.