jwithington

CODE SETTINGS SYNC UPLOAD SUMMARY
Version: 3.2.4
--------------------

Restarting Visual Studio Code may be required to apply color and file icon theme.
--------------------
Files Uploaded:
  extensions.json > extensions.json
  settings.json > settings.json

jwithington

Resources to look into

from JS Party 80

• You Dont know JS](https://github.com/getify/You-Dont-Know-JS)
• Essential Dsign patterns
• https://jrsinclair.com/
• https://medium.com/@_ericelliott
• https://polyfill.io/v3/

jwithington

// SpreadsheetApp.getActiveSpreadsheet().getSheets(); =>
const getSheets = [
  {getName: 'tab1', getRange: {getValues: [['one', 'One'], ['two', 'Two']] } },
  {getName: 'tab2', getRange: {getValues: [['a', 'A',], ['b', 'B']] } },
  {getName: 'tab3', getRange: {getValues: [['1', '!'],['2', '@']] } },
  {getName: 'tab4-skipit', getRange: {getValues: [['', '!'],['2', '@']] } },
  {getName: 'tab5-skipit', getRange: {getValues: [['1', '!'],['', '']] } }
]

function joinWithTabName(accumulator, val) {

jwithington

function columnsExportText() {
  //create main array to store data
  var everything = [];
  
  // get values from active sheet
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  
  // loop over each tab/sheet
  for (var j = 0; j < sheets.length ; j++ ) {
    var collected = []; // array to collect each loop

jwithington

function columnsExportText() {
  //create main array to store data
  var everything = [];
  
  // get values from active sheet
  var sheets = SpreadsheetApp.getActiveSpreadsheet().getSheets();
  
  // loop over each tab/sheet
  for (var j = 0; j < sheets.length ; j++ ) {
    var collected = []; // array to collect each loop

jwithington

function columnsExportText() {
  // get values from active sheet
  var sheet = SpreadsheetApp.getActiveSheet();
  var tabName = sheet.getName();
  var range = sheet.getRange(2, 1, sheet.getLastRow() -1, 2); 
  var data = range.getValues();

  //create new array to store data
  var collected = [];
 

jwithington

function columnsExportText() {
  // get values from active sheet
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  
  //create new array to store data
  var collected = [];
 
  // loop through and add info to collection with format of Text : "Text"
  for (var i = 0; i < data.length; i++) {

jwithington

{
    "git.ignoreMissingGitWarning": true,
    "window.zoomLevel": 1,
    "editor.tabSize": 2,
    "workbench.colorTheme": "Cobalt2",
    "workbench.colorCustomizations": {
        "[Pink Cat Boo]": {
            "titleBar.activeBackground": "#202330"
            //"activityBar.foreground": 
        }

jwithington

Full-screen animated gif background-APT!

A Pen by Jim Withington on CodePen.

License.

jwithington

#tcb sync