Make Student Result By google Sheet & web App script

नमस्‍कार दोस्‍तो,

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल शीट के डेटा से Student का Result कैसे बनाते है ा

How to Make Online Student Result by Google Sheet & Web App Script To easily

For Practical click to Below Practical Link

Practical

Result Output

Following this Step to make Result

Step 1 :- Click to Google Sheet Copy With Source Code

Step 2 :- Click to Google Sheet>> Extensions Click >> App Script>>

Step 3 :- Create to 4 file name given below

code.gs

home.html

result.html

error.html

Step 4 :- Below code copy and paste to Create File (Step 3)

and Change Google Sheet ID

Code.gs

function doGet(e) { var htmlOutput = HtmlService.createTemplateFromFile('home'); htmlOutput.result = 'Home'; return htmlOutput.evaluate(); } function doPost(e){ Logger.log(JSON.stringify(e)); if(e.parameter.Submit == 'Get Result'){ var cls = e.parameter.cl; var roll = e.parameter.rl; var ss = SpreadsheetApp.openById('1JWPUP4JsOYGQ3_bkQDOrIjs1piVU2jI4vx7YBuenYdo'); var ws = ss.getSheetByName(cls) var lr = ws.getLastRow(); for(var i = 1;i <= lr;i++){ var val = ws.getRange(i, 1).getValue(); if(val == roll) { var v1 = ws.getRange(i, 2).getValue(); var v2 = ws.getRange(i, 3).getValue(); var v3 = ws.getRange(i, 4).getValue(); var v4 = ws.getRange(i, 5).getValue(); var v5 = ws.getRange(i, 6).getValue(); var v6 = ws.getRange(i, 7).getValue(); var v7 = ws.getRange(i, 8).getValue(); var v8 = ws.getRange(i, 9).getValue(); var v9 = ws.getRange(i, 10).getValue(); }} var htmlOutput = HtmlService.createTemplateFromFile('result'); htmlOutput.cl = cls; htmlOutput.id = roll; htmlOutput.stn = v1; htmlOutput.fa = v2; htmlOutput.tm = v3; htmlOutput.re = v4; htmlOutput.hi = v5; htmlOutput.en = v6; htmlOutput.mt = v7; htmlOutput.sc = v8; htmlOutput.co = v9; return htmlOutput.evaluate(); }else{ var htmlOutput = HtmlService.createTemplateFromFile('home'); htmlOutput.result = ''; return htmlOutput.evaluate(); }}; function getUrl() { var url = ScriptApp.getService().getUrl(); return url; }

Step 5 :- Below code copy and paste to home.html Create File (Step 3)

home.html

<!DOCTYPE html> <center> <html> <head> <base target="_top"> <style> select,input{ padding:5px; width:100%; border:1px solid; margin:1px; font-family:times} input:hover{ background:orange;} </style> </head> <body> <table border="0" width='200px' cellspacing="0" > <tr> <td width=20% align=center> <?var url = getUrl();?> <form method="post" action="<?= url ?>" > <select name='cl'> <option value="0">Select Class:</option> <option value="1">1</option> <option value="2">2</option> <option value="3">3</option> <option value="4">4</option> <option value="5">5</option> </select> </br></br> <input type="text"name="rl" placeholder="Roll No"> </br></br> <input type="submit" value="Get Result" name="Submit"> </form> </td> </tr><tr> <td align=center> <span><?= result ?></span><br> </td> </tr> </table> </body> </center> </html>

Step 6 :- Below code copy and paste to result.html Create File (Step 3)

result.html

<html> <center> <head> <base target="_top"> <style> input{ width:15%; border:1px dashed black; margin:1px;} input:hover{ background:red;} table { font-family: times; border-collapse:collapse; width: 30%; } td, th { border: 1px solid #dddddd; text-align: left; padding: 8px;border:1px solid green; } tr:nth-child(even) { background-color: #dddddd; } </style> </head> <body> <table border="2" width=100% cellspacing="0" > <tr> <td>Class:</td> <td><?= cl ?></td> </tr><tr> <th>Roll No:</th> <th><?= id ?></th> </tr><tr> <td>Student name:</td> <td><?= stn ?></td> </tr><tr> <td>Father Name:</td> <td><?= fa ?></td> </tr><tr> <td>Hindi:</td> <td><?= hi ?></td> </tr> <td>English:</td> <td><?= en ?></td> </tr> <td>Math:</td> <td><?= mt ?></td> </tr> <td>Science:</td> <td><?= sc ?></td> </tr> <td>Computer:</td> <td><?= co ?></td> </tr> <td>Total Marks:</td> <td><?= tm ?></td> </tr><tr> <td>Grade:</td> <td><?= re ?></td> </tr> <tr> <td colspan=2 align=center> <?var url = getUrl();?> <form method="post" action="<?= url ?>"> Back to <input type="submit" value="Home" name="back"></form></td> </tr> </table> </body> </center> </html>

Step 7 :- Below code copy and paste to error.html Create File (Step 3)

error.html

<!DOCTYPE html> <html> <head> <base target="_top"> </head> <body> Sunrise iT Education </body> </html>

Step 8 :- Click here to >> Deploy >> New Deployment >>

8 Comments

kamar jan suvidha kendraMarch 10, 2022 at 1:05 PM
esme Print Ka Option De Den To Accha Hoga
PintuMarch 16, 2022 at 5:57 PM
How add students photos pls send code or make a video
I have been subscribed your channel. Advanced thanks
chandan kumarJune 1, 2022 at 11:01 PM
some common problem not see the other use
MilindAugust 29, 2022 at 7:08 PM
SyntaxError: Unexpected token '<' (line 42, file "code")

error ocuure in

return htmlOutput.evaluate();
this line
please solve problem as soon as possible.
Auraiya educational institutionsSeptember 15, 2022 at 4:06 PM
Embed नही हो रहा है
AKASH SIR (Enginner)January 4, 2023 at 2:22 PM
sir mere to online data result show hi nhi kar rah hai
AKASH SIR (Enginner)January 4, 2023 at 10:37 PM
hello sir mera open by id copy karke dalne par result show nhi kar rha hai

Make Student Result By google Sheet & web App script

How to Make Online Student Result by Google Sheet & Web App Script To easily

For Practical click to Below Practical Link

Practical

Result Output

Following this Step to make Result

Step 1 :- Click to Google Sheet Copy With Source Code

Step 2 :- Click to Google Sheet>> Extensions Click >> App Script>>

Step 3 :- Create to 4 file name given below

code.gs

home.html

result.html

error.html

Step 4 :- Below code copy and paste to Create File (Step 3)

and Change Google Sheet ID

Code.gs

Step 5 :- Below code copy and paste to home.html Create File (Step 3)

home.html

Step 6 :- Below code copy and paste to result.html Create File (Step 3)

result.html

Step 7 :- Below code copy and paste to error.html Create File (Step 3)

error.html

Step 8 :- Click here to >> Deploy >> New Deployment >>

More Detail See Video :-

8 Comments

Donation and Support

Contact Form