How to publish student result in blogger website using google appscript

This file takes an Apps Script result portal and puts it inside your own Blogger website, so students check their marks on your site instead of following a long script.google.com link. It is the follow-on to the school result portal build: you set that code up first, then this one handles the embedding and the error that stops it working.

The refused to connect fix

Drop a web app URL into a Blogger page the usual way and the browser blocks it with a refused to connect message. That is the problem this file exists to solve. You get the exact snippet to paste into the Blogger page, with the height and width values that make the portal display properly, and the embed loads instead of failing.

What the student sees

A student opens your Blogger page, types a roll number, picks a class and presses Get Result. The marksheet comes back with each subject, the maximum marks, the obtained marks, the total, the percentage and a pass or fail status, and they can print it from the page. The link you hand out is a normal page on your site, not a raw web app address.

Marks logic you control

Subject names come from the sheet headers, so renaming a column renames it on the result. Totals are not typed by anyone: whatever maximum marks you enter are added up, and so are the obtained marks, with the percentage following. The pass mark sits at forty percent and is a single value to change if your school passes at thirty-three. Grades are the one column you fill in yourself.

Sheet layout matters

Add as many class tabs as you need, but keep the header layout identical on each one — the code reads a fixed pattern, so a shifted row is the usual cause of a blank result. Paste your spreadsheet ID into the script, run it once to authorise, then deploy and copy the URL into Blogger.