Student Management Web App with Google Apps Script | WEB APP Google Sheets | B20

B20 is a student records app that solves the photo problem properly. Most sheet-driven apps expect you to host an image somewhere else and paste a URL into a column. Here the upload happens inside the app: you pick the picture when you add the student, it goes to your Google Drive folder, and it shows next to their record from that moment on.

Adding a student

The form takes a first name, father's name, last name, email, student ID, semester, year of graduation and the photo. If a name already exists, the app says so rather than quietly creating a second record for the same person — which is what usually turns a student list into a mess by the second intake.

Filters that build themselves

First name, last name, student ID and year of graduation each get a filter dropdown, and those dropdowns are built from what is actually in the sheet. Add a student graduating in 2027 and 2027 appears as a filter option by itself. Nothing is maintained by hand, so the filters cannot drift out of date.

It refreshes without being asked

The table re-reads the sheet on a timer — three seconds as supplied — so a change made directly in the spreadsheet shows up in the app without anybody reloading anything. That interval is a number in the code: set it to nine thousand for nine seconds, or longer if the data does not move often.

One setup step that catches people

Besides pasting your sheet ID and folder ID, the Drive folder holding the photos has to be shared so anyone can view it. If it stays private, you will see the images and everybody else will see blanks — the app works, the pictures just do not reach other viewers.