Make Online Results

How to Make Marksheet online

Download Google Sheet

Paste This Code in Appscript

Index.html

<!DOCTYPE html>
<html>
    <head>
        <base target="_self">
        <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/css/bootstrap.min.css" integrity="sha384-TX8t27EcRE3e/ihU7zmQxVncDAy5uIKz4rEkgIXeMed4M0jlfIDPvg6uqKI2xXr2" crossorigin="anonymous">
       
   <style>
   
   /* h5 {background: red;} */
   
   </style>

        
    </head>
    <body>
        <div class="container">
            <br>
            <div class="row">
              <div class="col">
            
                  <!-- ## SEARCH FORM ------------------------------------------------ -->
                  <center><form id="search-form" onsubmit="handleFormSubmit(this)">
                    <div class="form-group mb-2">
                    <center>
                    <img src="https://drive.google.com/uc?id=1IEbmRqC62sUIKx-FTOhzeVTaKiRKx5Tf" alt="Kyothar Central School" width="200">
                    </center>
                    
                      <h5 for="searchtext">Student Result</h5>
                    </div><p>
                    <div class="form-group mx-sm-3 mb-3">
                      <input type="text" class="form-control col-sm-6" id="searchtext" name="searchtext" placeholder="Search Roll No"><br>
                    </div><p>
                    <button type="submit" class="btn btn-primary mb-2">Search Result</button>
                    <span id="resp-spinner5" class="spinner-grow spinner-grow-sm text-danger d-none" role="status" aria-hidden="true"></span>
                    <span id="resp-spinner6" class="spinner-grow spinner-grow-sm text-warning d-none" role="status" aria-hidden="true"></span>
                    <span id="resp-spinner7" class="spinner-grow spinner-grow-sm text-info d-none" role="status" aria-hidden="true"></span>
                  </form></center>
                  <!-- ## SEARCH FORM ~ END ------------------------------------------- -->
              
              </div>    
            </div>
            <div class="row">
              <div class="col">
            
                <!-- ## TABLE OF SEARCH RESULTS ------------------------------------------------ -->
                <div id="search-results" class="table-responsive">
                  <!-- The Data Table is inserted here by JavaScript -->
                </div>
                <!-- ## TABLE OF SEARCH RESULTS ~ END ------------------------------------------------ -->
                  
              </div>
            </div>
        </div>
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.5.3/dist/js/bootstrap.min.js" integrity="sha384-w1Q4orYjBQndcko6MimVbzY0tgp4pWB4lZ7lr30WKz0vr/aWKhXdBNmNb5D92v7s" crossorigin="anonymous"></script>
        <!--##JAVASCRIPT FUNCTIONS ---------------------------------------------------- -->
        <script>
          //PREVENT FORMS FROM SUBMITTING / PREVENT DEFAULT BEHAVIOUR
          function preventFormSubmit() {
            var forms = document.querySelectorAll('form');
            for (var i = 0; i < forms.length; i++) {
              forms[i].addEventListener('submit', function(event) {
              event.preventDefault();
              });
            }
          }
          window.addEventListener("load", preventFormSubmit, true); 
             
          
          //HANDLE FORM SUBMISSION
          function handleFormSubmit(formObject) {
           if(document.getElementById('searchtext').value == "" || document.getElementById('searchtext').value == ""){
              alert("Fill Roll No");
           }else{
             document.getElementById('resp-spinner5').classList.remove("d-none");
             document.getElementById('resp-spinner6').classList.remove("d-none");
             document.getElementById('resp-spinner7').classList.remove("d-none");
            google.script.run.withSuccessHandler(createTable).processForm(formObject);
            document.getElementById("search-form").reset();
           };
          };
        
          //CREATE THE DATA TABLE
          function createTable(dataArray) {
             document.getElementById('resp-spinner5').classList.add("d-none");
             document.getElementById('resp-spinner6').classList.add("d-none");
             document.getElementById('resp-spinner7').classList.add("d-none");
            if(dataArray && dataArray !== undefined && dataArray.length != 0){
              var result = "<table class='table table-sm table-striped' id='dtable' style='font-size:0.8em'>"+
                           "<thead style='white-space: nowrap'>"+
                             "<tr>"+                               //Change table headings to match with the Google Sheet
                              "<th scope='col'></th>"+
                            "</tr>"+
                          "</thead>";
              for(var i=0; i<dataArray.length; i++) {
                  result += "<tr>";
                  for(var j=0; j<dataArray[i].length; j++){
                      result += "<td>"+dataArray[i][j]+"</td>";
                  }
                  result += "</tr>";
              }
              result += "</table>";
              var div = document.getElementById('search-results');
              div.innerHTML = result;
            }else{
              var div = document.getElementById('search-results');
              //div.empty()
              div.innerHTML = "Result Not found!";
            }
          }
        </script>
        <!--##JAVASCRIPT FUNCTIONS ~ END ---------------------------------------------------- -->    
    
    </body>
</html>

Code.gs

function myFunction123() {
  var foldername = 'AutoCrat Demo';
  var folderlisting = 'Sunrise IT Education ' + foldername;
  
  var folders = DriveApp.getFoldersByName(foldername)
  var folder = folders.next();
  var contents = folder.getFiles();
  var contents = folder.getFiles();
  
  var ss = SpreadsheetApp.create(folderlisting);
  var sheet = ss.getActiveSheet();
  sheet.appendRow(['File Name','link']);
  
  var file;
  var name;
  var link;
  var row; 
  while(contents.hasNext()){
    file = contents.next();
    name = file.getName();
    link = file.getUrl();
    sheet.appendRow([name, link]);
  }
  
};

Code1.gs

Change the spreadsheet id from Google sheet in the line 22

function doGet(e) {
  
  return HtmlService.createTemplateFromFile("Index").evaluate()
  .setTitle("WebApp: Search By Password")
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}


/* PROCESS FORM */
function processForm(formObject){ 
  var concat = formObject.searchtext;
  var result = "";
  if(concat){//Execute if form passes search text
      result = search(concat);
  }
  return result;
}

//SEARCH FOR MATCHED CONTENTS ;
function search(searchtext){
  var spreadsheetId   = '1ZVSL20C9F3X7hNwnuhpf3U8eHu2Fn0t3dua1YVlbPY0'; //** CHANGE !!!!
  var sheetName = "Data"
  var range = SpreadsheetApp.openById(spreadsheetId).getSheetByName(sheetName).getDataRange();
  var data = range.getValues();
  var ar = [];
  
  data.forEach(function(f) {
    if (~[f[0]].indexOf(searchtext)) {
      ar.push([f[2] ]);
    }
  });
                                           
  return ar;
};

Link For Google Chart (QR Code Generation):

="https://chart.googleapis.com/chart?cht=qr&chs=300x300&chl="&ENCODEURL($A$1&"- "&A2&", "&$B$1&" - "&B2&", "&$C$1&" - "&C2&", "&$D$1&" - "&D2&", "&$E$1&" - "&E2&", "&$F$1&" - "&F2&", "&$G$1&" - "&G2&", "&$H$1&" - "&H2&", "&$I$1&" - "&I2&", "&$J$1&" - "&J2&", "&$K$1&" - "&K2&", "&$L$1&" - "&L2&", "&$M$1&" - "&M2&", "&$O$1&"- "&O2)

To Show The Image of qr Code

=IMAGE($E2)

Image Url in Google Sheet

Put the Id of.image

https://docs.google.com/thumbnail?sz=w150&h200&id=10Q7Xj8J3ozAmxYR6S_4enJ4mMSob1cf2

Some Excel Formula

Add:-

=SUM(D2:H2)

Subtract:-

=SUM(D2:-H2)

Multiply:-

=A2*B1*C2

Division:-

=B2/A2

Percentage:-

=SUM(D2:H2)/5

Average:-

=AVERAGE(D2:H2)

Count:-

=COUNT(D2:H2)

Round :-

=ROUND(D2,0)

Chanda Om Official

Header Ads Widget

Chanda Om Official

Make Online Results

Download Google Sheet

Paste This Code in Appscript

Index.html

Code.gs

Code1.gs

Change the spreadsheet id from Google sheet in the line 22

Link For Google Chart (QR Code Generation):

To Show The Image of qr Code

Image Url in Google Sheet

Some Excel Formula

Post a Comment

0 Comments

Recently Upload

Url/Link Encoder and decoder tool

Labels

Popular Posts

Download Any Youtube Video

Categories

Most Recent

Random Posts

Most Popular

Download Any Youtube Video

Holi Ka Calendar wala Poster । Holi Ka Poster Kaise Banaye

Menu Footer Widget

Chanda Om Official

Header Ads Widget

Chanda Om Official

Make Online Results

Download Google Sheet

Paste This Code in Appscript

Index.html

Code.gs

Code1.gs

Change the spreadsheet id from Google sheet in the line 22

Link For Google Chart (QR Code Generation):

To Show The Image of qr Code

Image Url in Google Sheet

Some Excel Formula

Post a Comment

0 Comments

Recently Upload

Url/Link Encoder and decoder tool

Labels

Social Plugin

Popular Posts

Download Any Youtube Video

Categories

Most Recent

Random Posts

Most Popular

Download Any Youtube Video

Holi Ka Calendar wala Poster । Holi Ka Poster Kaise Banaye

Menu Footer Widget