ramboviking

Track health declaration using Google Form. Function extension with Google Apps Script.

• Create spreadsheet for each user.
• Send notification to users.
• Send notification to leader when user submit.

function onOpen() {
  let ui = SpreadsheetApp.getUi();
  ui.createMenu('Tracker')
    .addItem('Create shared sheet', 'createSheets')

ramboviking

Apps Script support build-in function folder.getFiles() to get files in a folder. But it 's not include files in subfolder. So I wrote function listAllFiles to resolve it.

listAllFiles(folderId, [mimeType], [depth])

Get all files in a folder - include subfolder - as a Array of id. @Return Array of files id

Parameters

| Name | Type | Description |

ramboviking

First row

Get first row contain value in the active Sheet (1-Index). Return 1 for empty sheet.

function getFirstRow() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var lastColumn = sheet.getLastColumn();
  var lastRow = sheet.getLastRow();