Free Result Marksheet with Certificate Link – Apps Script

FREE023 is the result portal where the student sees their own face on the marksheet. A roll number goes in, and what comes back carries the photo, the name, the father's name, the subject marks and a pass or fail verdict — printable, and recognisably that child's result rather than a row of numbers.

Why the photo matters

A marksheet with a picture on it is harder to pass off as somebody else's and easier for a parent to trust. The image is a URL held against that student in the sheet, so you manage it the same way you manage everything else here — by typing in a spreadsheet.

Certificates for the ones who earned them

There is a certificate link on the result as well. If a student took first position, or completed something worth recording, paste that certificate's URL into their row and it appears on their result. Leave it empty for everyone else and nothing shows.

Built for any curriculum

The subject names are read from the sheet, so a school in India, Pakistan or anywhere else types in its own subjects — Computer, Social Science, whatever the syllabus is — and the result follows. The code loops over however many subjects there are rather than expecting a fixed set, so extending the list does not break it.

Totals and the pass mark

Total marks can be a figure you type — 600 for six papers of 100 — or a SUM formula across the marks range, which is the safer choice if the maximums differ per subject. The pass line sits at thirty three percent: below it the result reads Failed, above it Pass, and the walkthrough flips a student between the two to show it working.

Setting it up

No coding knowledge assumed. The portal title becomes your school's name by typing it in, and the whole thing is driven from the spreadsheet.