Google Sheet open by ID and Password

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

इस ब्‍लॉग में हम आपको बहुत ही सरल भाषा में बतायेगें की किस प्रकार गुगल शीट को किस प्रकार आई0डी0 एवं पासवर्ड की मदद से कैसे Protect किया जा सकता है ा

अत- आप इसकी मदद से अपनी गुगल शीट को Protecte कर सकते है एंव अपने डेटा को Secure कर सकतें है ा

How to Google Sheet Open By ID and Password (Google Sheet Protected By Password)

In this blog we will tell you How to Google Sheet Open By ID and Password so read the complete blog carefully and learn How to Google Sheet Open By ID and Password according to given guidelines.

For Practical :- User ID- site & Password :- 123

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

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

Step 3 :- Create 2 file Name Given Below
Code.gs
Index.html

Step 4 :- Click to Copy Below Code and Paste to Code.gs File

function doGet(e) {
  
  return HtmlService.createTemplateFromFile("Index").evaluate()
  .setTitle("Sunrise IT Education")
  .addMetaTag('viewport', 'width=device-width, initial-scale=1')
  .setXFrameOptionsMode(HtmlService.XFrameOptionsMode.ALLOWALL);
}


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

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

Step 5 :- Click to Copy Below Code and Paste to Index.html File

<!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">
                      <h5 for="searchtext">Welcome</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="User ID"><br>
                      <input type="password" class="form-control col-sm-6" id="searchtext2" name="searchtext2" placeholder="Password">
                    </div><p>
                    <button type="submit" class="btn btn-primary mb-2">Login</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('searchtext2').value == ""){
              alert("Fill in Name and Password");
           }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:1.0em'>"+
                           "<thead style='white-space: nowrap'>"+
                             "<tr>"+                               //Change table headings to match with the Google Sheet
                            "</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 = "User ID & Password Wrong!";
            }
          }
        </script>
        <!--##JAVASCRIPT FUNCTIONS ~ END ---------------------------------------------------- -->    
    
    </body>
</html>

Google Sheet open by ID and Password

How to Google Sheet Open By ID and Password (Google Sheet Protected By Password)

In this blog we will tell you How to Google Sheet Open By ID and Password so read the complete blog carefully and learn How to Google Sheet Open By ID and Password according to given guidelines.

For Practical :- User ID- site & Password :- 123

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

Step 3 :- Create 2 file Name Given Below
Code.gs
Index.html

Step 4 :- Click to Copy Below Code and Paste to Code.gs File

Step 5 :- Click to Copy Below Code and Paste to Index.html File

Step 6 :- Code.gs File Line No 22 Paste to Google Sheet ID

https://docs.google.com/spreadsheets/d/Google Sheet ID/edit#gid=0

Step 7 :- Click to Save

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

More Detail See Video :-

Post a Comment

Donation and Support

Contact Form

Google Sheet open by ID and Password

How to Google Sheet Open By ID and Password (Google Sheet Protected By Password)

In this blog we will tell you How to Google Sheet Open By ID and Password so read the complete blog carefully and learn How to Google Sheet Open By ID and Password according to given guidelines.

For Practical :- User ID- site & Password :- 123

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

Step 3 :- Create 2 file Name Given BelowCode.gsIndex.html

Step 4 :- Click to Copy Below Code and Paste to Code.gs File

Step 5 :- Click to Copy Below Code and Paste to Index.html File

Step 6 :- Code.gs File Line No 22 Paste to Google Sheet ID

https://docs.google.com/spreadsheets/d/Google Sheet ID/edit#gid=0

Step 7 :- Click to Save

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

More Detail See Video :-

Post a Comment

Contact Form

Step 3 :- Create 2 file Name Given Below
Code.gs
Index.html