Apna Tool
🚀 Favourite Tools
Tools: 0
Image Compressor
Image Format Converter
Premium Digital Signature Maker
Photo Name and Date Joiner
Image Compressor With Custom Size
Image Compressor Simple
WebP to JPG Converter
Photo Name Joiner
Image Enhancer Professional
Photo Resizer
Passport Photo Grid Generator (A4)
Photo ko Middle Me Adjust Karen
Passport Photo Grid Generator 4x6
Passport Photo Maker (Pro) 6x6 Download as PNG PDF
Passport Photo Maker
JPEG To PDF
Scan to PDF
PDF Viewer
Add Watermark to PDF
Rotate PDF
Add Page Numbers to PDF
Mobile Scan to PDF
PDF Splitter
Image to PDF Converter
Multiple PDFs (One per Image)
Merge PDFs
Compress PDF
Age Calculator
Kruti Dev To Unicode
Billing & Export
Google Drive Direct Link Generator
Generate iframe Embedded Code
Mirrored Text Generator
Text Analyzer
Sign PDF Draw Signature
Stock Management Tool
Signature Resizer Fo SSC Or Govt Form
Remove Background in Just a Second
search Data in One Click By Roll Number
Search Data
search Student Data One Click By Roll Number
index.html
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
body{
font-family:Arial;
background:#f2f2f2;
padding:20px;
}
.box{
max-width:700px;
margin:auto;
background:white;
padding:20px;
border-radius:10px;
box-shadow:0 0 10px #ccc;
}
input{
width:100%;
padding:10px;
margin:10px 0;
}
button{
padding:10px 20px;
background:green;
color:white;
border:none;
cursor:pointer;
}
img{
max-width:150px;
margin:10px 0;
border:1px solid #ccc;
}
#result{
margin-top:20px;
}
</style>
</head>
<body>
<div class="box">
<h2>Madrsa Faizane Raza Lilbanat</h2>
<input
type="text"
id="srno"
placeholder="Enter SR No">
<button onclick="searchStudent()">
Search Student
</button>
<div id="result"></div>
</div>
<script>
function searchStudent(){
let srno =
document.getElementById("srno").value;
google.script.run
.withSuccessHandler(showStudent)
.getStudent(srno);
}
function showStudent(data){
if(data.found){
document.getElementById("result")
.innerHTML=`
<img src="${data.photo}">
<h3>${data.name}</h3>
<p><b>SR No:</b> ${data.srno}</p>
<p><b>Father:</b> ${data.father}</p>
<p><b>Class:</b> ${data.class}</p>
<p><b>Mobile:</b> ${data.mobile}</p>
<p><b>Aadhaar:</b> ${data.aadhaar}</p>
<p><b>Address:</b> ${data.address}</p>
<img src="${data.signature}">
`;
}
else{
document.getElementById("result")
.innerHTML =
"<h3>Student Not Found</h3>";
}
}
</script>
</body>
</html>
code.gs
function doGet() {
return HtmlService.createHtmlOutputFromFile("Index");
}
function getStudent(search){
var sheet = SpreadsheetApp
.getActiveSpreadsheet()
.getSheetByName("Students");
var data = sheet.getDataRange().getValues();
for(var i=1;i<data.length;i++){
if(String(data[i][0]) == search){
return {
found:true,
srno:data[i][0],
name:data[i][1],
father:data[i][2],
mobile:data[i][3],
aadhaar:data[i][4],
class:data[i][5],
address:data[i][6],
photo:data[i][7],
signature:data[i][8]
};
}
}
return {
found:false
};
}
Agar phir bhi photo na aaye
Browser me alag se ye URL kholiye:
ttps://drive.google.com/thumbnail?id=1opHtHs_lr-ZnuYz45j-W3xps9Trxdj42&sz=w1000
Aur:
https://drive.google.com/thumbnail?id=1XvhR4G1a8VZ0m7QMpFDvLXAE-wQvQipO&sz=w1000
Agar browser me image khul jati hai to dashboard me bhi dikhegi.
Test Link





