Setup Video Guide Video
Please Follow The Steps Here
Now Click on Extension and Choose a Appscript Option
After Deploy Allow Permission After Permission Given a URL Comes Which
is Used to Access Your Web App and if You change in codes after
deployment You need to apply Changes Need Deploy Again or Manage
Deployments,
Click 'Watch Now' to learn how to get a
Google Sheet link or make a copy
and Download Code!
Make a Sheet Copy
Contact us For Project
Join Whatsapp Community
Code.gs
function doGet() {
return HtmlService.createTemplateFromFile('index')
.evaluate()
.addMetaTag('viewport', 'width=device-width, initial-scale=1')
.setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL)
}
function include(filename) {
return HtmlService.createHtmlOutputFromFile(filename).getContent();
}
function sub(v){
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName("Sheet1");
var flag = 1 ;
var lr = sheet.getLastRow();
for(var i = 2;i <= lr;i++){
if(v.roll == sheet.getRange(i, 1).getValue()){
flag = 0;
var tt = sheet.getRange(1, 2).getValue();
var h1 = sheet.getRange(1, 3).getValue();
var h2 = sheet.getRange(1, 5).getValue();
var h3 = sheet.getRange(1, 6).getValue();
var h4 = sheet.getRange(1, 7).getValue();
var h5 = sheet.getRange(1, 8).getValue();
var h6 = sheet.getRange(1, 9).getValue();
var h7 = sheet.getRange(1, 10).getValue();
var b1 = sheet.getRange(i, 2).getValue();
var b2 = sheet.getRange(i, 3).getValue();
var b3 = sheet.getRange(i, 4).getValue();
var m1 = sheet.getRange(i, 5).getValue();
var m2 = sheet.getRange(i, 6).getValue();
var m3 = sheet.getRange(i, 7).getValue();
var m4 = sheet.getRange(i, 8).getValue();
var m5 = sheet.getRange(i, 9).getValue();
var m6 = sheet.getRange(i, 10).getValue();
var lo = "Logo URL HERE";
var data ='<table class="tg"><thead><tr><th class="tg-0pky">
<img src='+lo+' height="50px"width="50px"></th><th class="tg-0pky" colspan="5">
<h4>'+tt+'</h4></th></tr></thead><tbody><tr><td class="tg-0pky">Roll No.</td>
<td class="tg-0pky">'+v.roll+'</td><td class="tg-0pky">Name:</td>
<td class="tg-0pky"colspan="3">'+b1+'</td></tr><tr>
<td class="tg-0pky"colspan="6">Results:</td></tr><tr>
<td class="tg-0pky">slr.</td><td class="tg-0pky">Competition</td>
<td class="tg-0pky">Maximum score</td><td class="tg-0pky">CutOff Score</td>
<td class="tg-0pky">Obtained Score</td><td class="tg-0pky">Remarks</td></tr>
<tr><td class="tg-0pky">1.</td><td class="tg-0pky">Reasoning</td>
<td class="tg-0pky">'+h2+'</td>
<td class="tg-0pky">11.50</td>
<td class="tg-0pky">'+m1+'</td><td class="tg-0pky">Passed</td></tr>
<tr><td class="tg-0pky">2.</td><td class="tg-0pky">General awareness</td>
<td class="tg-0pky">'+h3+'</td><td class="tg-0pky">17.10</td><td class="tg-0pky">'+m2+'</td>
<td class="tg-0pky">Passed</td></tr><tr><td class="tg-0pky">3.</td>
<td class="tg-0pky">Computer knowledge</td><td class="tg-0pky">'+h4+'</td>
<td class="tg-0pky">29.20</td><td class="tg-0pky">'+m3+'</td>
<td class="tg-0pky">Passed</td></tr><tr><td class="tg-0pky">4.</td>
<td class="tg-0pky">English</td><td class="tg-0pky">'+h5+'</td>
<td class="tg-0pky">23.50</td><td class="tg-0pky">'+m4+'</td>
<td class="tg-0pky">not Passed</td></tr><tr><td class="tg-0pky">5.</td>
<td class="tg-0pky">Hindi</td><td class="tg-0pky">'+h6+'</td>
<td class="tg-0pky">-</td><td class="tg-0pky">'+m5+'</td>
<td class="tg-0pky">-</td></tr><tr><td class="tg-0pky">6.</td>
<td class="tg-0pky">Quantitative aptitude</td>
<td class="tg-0pky">'+h7+'</td><td class="tg-0pky">30.10</td>
<td class="tg-0pky">'+m6+'</td><td class="tg-0pky">Passed</td>
</tr></tbody><tfooter><tr><td class="tg-0pky"colspan="2">Total</td>
<td class="tg-0pky">'+h1+'</td><td class="tg-0pky">111.4</td>
<td class="tg-0pky">'+b2+'</td><td class="tg-0pky"></td></tr>
</tfooter></table>*This provisional result intimation is issued as a notice only.
Errors and omissions excepted. If a candidate finds any discrepancy in the Result
Intimation or desires correction in any of the particulars, he/she may contact the
Board within 30 days after declaration of the result. Any entry appearing in it does
not itself confer any right or privilege independently for the grant of proper certificate,
which will be issued under the Rules/ Regulations.<br>(ii)The Star (*) indicates that
the candidate has passed the subject/s with concessional marks under Board Rule.
In case he/she is not willing to accept the concessional marks, necessary permission
to reappear in the subject/s may be obtained within the schedule for submission of
admission form and fee for the next immediate examination provided he/she has the
chance/s to re-appear as a compartment candidate in the said examination.
<br>(iii)Candidate intending to apply for re-checking of his/her paper/s may
apply Online within 15 days after declaration of the result.
<br>(iv)A candidate intending to improve his/her grade or marks are
allowed to appear in Subject/s or Part-I or Part-II or both with one
examination opportunity within one year of passing relevant examination i
n the same group/subjects in current/prevalent syllabus. If the candidate
qualified subject/s with concessional marks, he/she will also have to appear
and qualify in those subject/s for improvement of marks/grade. In case a candidate
fails to improve his/her marks/grade in any part or subject/s, his/her previous
result will remain intact.';
return data;
}
}
if(flag==1){
var data ="Roll Number NOT Found. Please Enter Correct Roll Number";
return data;
}
};
If You face Error In Copy Codes Then the Sheet Copy Option Available Avail the Copy Sheet Option
Index.html
<!DOCTYPE html>
<html>
<base target="_top">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://www.w3schools.com/w3css/4/w3.css">
<link rel="stylesheet"
href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
<style>
.loader {margin-left:45%;
border: 10px solid #f3f3f3;
border-radius: 60%;
border-top: 2px solid #3498db;
width: 200px;
height: 200px;
-webkit-animation: spin 2s linear infinite;
animation: spin 2s linear infinite;
}
@-webkit-keyframes spin {
0% { -webkit-transform: rotate(0deg); }
100% { -webkit-transform: rotate(360deg); }
}
@keyframes spin {
0% { transform: rotate(0deg); }
100% { transform: rotate(360deg); }
}
.tg {border-collapse:collapse;border-spacing:5;width:1200px;}
.tg td{border-color:black;border-style:solid;border-width: 3px;font-family:Arial,
sans-serif;font-size:14px;}
.tg th{border-color:black;border-style:solid;border-width:3px;font-family:Arial,
sans-serif;font-size:14px;}
.tg .tg-0pky{border-color:inherit;text-align:left;vertical-align:top}
</style>
<body>
<div id="lod" class="w3-modal">
<div class="w3-center">
<div class="loader"></div>
</div>
</div>
<?!= include('js'); ?>
<div class="w3-row w3-small"style="margin-top:20px;margin-left:25%;">
<h4 >Result System FSC (ANNUAL Examination-2023)</h4>
<form id="lab" onsubmit="event.preventDefault();subm(this)">
<div class="w3-col s8"><br>
<input type="text"name="roll"placeholder="Enter Rgistration No"
class="w3-input w3-border w3-round-large w3-col s4"required><br><br>
<br>
<input type="submit"class="w3-button w3-green w3-round-large w3-col s2 w3-margin-left">
<br><br><br>
<input type="button" name="btnprint"class="w3-button w3-red w3-round-large w3-col s2
w3-margin-left" value="Print" onclick="Print('PrintDiv')"/>
</div>
</form>
</div>
<div id='PrintDiv'>
<div id="rs"class="w3-margin-top"style="margin-left:2%; margin-top:2%;"></div>
</div>
</body>
</html>
If You face Error In Copy Codes Then the Sheet Copy Option Available Avail the Copy Sheet Option
Terms of Use
If you want to use this Code in your posts, please don't remove the
attributes from the codes, it will not be visible on your website.
If you want to rewrite an article on this Codebox by using these codes, you
must add a Reference with visible and clickable link redirecting to our
website: https://www.rameezimdad.blogspot.com. If you rewrite without
Reference, Legal Actions will be taken.
Conclusion
This is all about to help uou to Automate Your Business. I hope you enjoy
this article. Please do share this article. And if you are facing problem in
any section or you have any question then ask us in comment box. Thank
you!