Sunday, April 29, 2018

106 Apps Script Google Sheet Search Record

106 Apps Script Google Sheet Search Record



.
106 Apps Script: Google Sheet Search Record

Objective:

1. Parameter cmd for getting commands from clients.
2. Function taskManager() to handle app-specific commands.
3. Add new codes to the existing Function getRecords() :
3.1. Read two new optional parameters searchval and searchcols.
3.2. Call Function FindInArray to search for searchval in searchcols.
3.3. Set result2 as search results.
3.4. If result2 is empty,

1. Create Spreadsheet and Script.

Spreadsheet: 106appdatacrud.
Dummy Data:
A
B
C
D
1
tid
timestamp
name
gmail
2
123
notarazi
notarazi@gmail.com
3
456
notaraza
notaraza@gmail.com
4
789
notarazu
notarazu@gmail.com
5
6
7
Sheet name: admins
Script: 106appdatacrudscript.

2. Add codes.

/*script id*/
var SCPID = ScriptApp.getScriptId();
/*active spreadsheet */
var SST = SpreadsheetApp.getActiveSpreadsheet();
/*active spreadsheet id*/
var SSTID = SpreadsheetApp.getActiveSpreadsheet().getId();
/*OR if you are writing a standalone script*/
/*var SSTID=1FhDxI7j0PFtQYF0gCsiAQauQ1QZ-nDTWNPydpQPD3GE*/
/* web request listeners */
/* pass request to handleResponse */
function doGet(e) {
  return handleResponse(e);
}
function doPost(e) {
  return handleResponse(e);
}
/* handle action request */
function handleResponse(e) {
  var lock = LockService.getPublicLock();
  lock.waitLock(30000); // wait 30 seconds before conceding defeat.
  try {
    var cmd = e.parameter.cmd;
    var output = [];
    if (cmd == "app") {
      output = taskManager("app", e);
    } else if (cmd == "getadmins") {
      output = taskManager("getadmins", e);
    } else if (cmd == "addadmin") {
      output = taskManager("addadmin", e);
    } else if (cmd == "setadmin") {
      output = taskManager("setadmin", e);
    } else if (cmd == "deladmin") {
      output = taskManager("deladmin", e);
    }
    return ContentService.createTextOutput(JSON.stringify({

visit link download
Posted by at

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

Subscribe to: Post Comments (Atom)