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
