How to Build an Advanced Online Result Portal using Google Sheets & google apps script

FREE028 handles the case every other result portal quietly gets wrong: a student who has more than one result on record. Pick your class, type your roll number, and every result held against it comes back — stacked one after another — rather than only the first or most recent.

Why that matters

Schools record more than one result per student as a matter of course: a mid term and a final, a monthly test and a term paper, a resit. A portal that returns a single match shows one of them and hides the rest, and neither the student nor the parent knows there was another. Here they see everything, in order, and can print the lot.

Classes are just sheets

Each class is its own tab, selected from a dropdown before the roll number is entered. There is no cap — add Class 1 through Class 5 and beyond by adding tabs with the same layout. The class name appears on the result so a printed copy identifies itself.

Everything stays editable

Results live in the sheet, so correcting a mark after the fact is an edit in the spreadsheet rather than a support request. Change it and the next lookup returns the corrected figure.

For the student

The result prints as it appears, so it can be handed over on paper or saved as a PDF. Nothing is typed by the student beyond their class and roll number.

Which result file to choose

This one is for records where a student legitimately has several results. The other result files here cover a single result per lookup, a fee defaulter gate, a student photo, an emailed one time code, or publishing a portal inside Blogger.