Multi-Branch Student Management System – Google Sheets

B32 is a student registration portal built for a school that runs more than one campus. One web app serves them all: each branch has its own Google Sheet, its own username and password, and staff at that branch only ever see their own students. The owner keeps the login list in a single admin spreadsheet and adds a new campus by pasting in a sheet ID.

One portal, many school databases

The login sheet lives only in the admin spreadsheet — the branch sheets must not carry one. To connect a new campus you create its spreadsheet, copy the headers in, paste its ID into the admin login sheet with a username, a password and the school name, and it is live. After signing in, the portal shows which school you are working in, so nobody enters a record against the wrong branch.

Classes pick themselves up

Add a tab for a class with the same headers and it appears in the class dropdown on its own; there is no list of classes to maintain in code. Each class shows a count of students found, and clicking the card opens the full list for that class.

Duplicates you can actually see

The portal counts duplicate entries per class and outlines those rows in red, so the same child admitted twice is obvious instead of buried in a sheet. A delete icon on the row removes the extra copy on the spot.

Adding a student

The add form takes admission number, date, student name, father's name, date of birth and email. The student ID is generated for you, though you can type your own. One point worth knowing before you buy: records can be added and deleted from the portal, but editing an existing student is done by the admin in the sheet, not on screen.