mderazon

/*
 * script to export data in all sheets in the current spreadsheet as individual csv files
 * files will be named according to the name of the sheet
 * author: Michael Derazon
*/

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}];
  ss.addMenu("csv", csvMenuEntries);

paulgambill

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

mi5ty

%%tana%%

• Cheat Sheet
  • ✨ Tana Expressions
    • Title #tana-expression
      • Description:: A title expression composes values from the node into a title.
      • Attributes:: Search for Tana "Title" Attributes
    • Search #tana-expression
      • Description:: The search expression consists of a flat list of match-clauses that must be true for a node to match the search.
      • Attributes:: Search for Search Attributes + Search for Search Field Values
• 🧩 Tana Attributes