google-apps-script-snippets

google-apps-script-snippets copied to clipboard

https://plus.google.com/+BruceMcpherson/posts/GCj8adr5QkZ

oshliaer

https://github.com/selectnull/eslint-plugin-googleappsscript/pull/2

oshliaer

```bash $> rsync -avrh --progress --exclude="node_modules" --exclude=".git" SRC DEST ```

oshliaer

Crop sheets feature

1

oshliaer

You do not have permission to call getEffectiveUser ```json "oauthScopes": [ "https://www.googleapis.com/auth/userinfo.email" ] ```

oshliaer

```js function onOpen(e) { try{ var __ = { s: e.range.getSheet() } __.lr = __.s.getLastRow(); __.mr = __.s.getMaxRows(); __.s.getRange(__.lr == __.mr ? __.lr : __.lr + 1, 1).activate(); } catch...

oshliaer

```js function makeTableHTML_(myArray) { var result = ""; for(var i=0; i

oshliaer

```js function myFunction() { var range = DocumentApp.getActiveDocument().getBody().findText("test.*"); Logger.log(range); Logger.log(extractTextFromFindText_(range)); } function extractTextFromFindText_(rangeElement){ return rangeElement ? rangeElement.getElement().asText().getText() .slice(rangeElement.getStartOffset(), rangeElement.getEndOffsetInclusive() + 1) : rangeElement; } ```

oshliaer

`https://www.googleapis.com/auth/script.scriptapp`

oshliaer

`getPreFillEntriesMap_(id)` returns an ordered array of the Form's items with their `entries` codes ```json [ { "id": 1144844846, "entry": "1854759972", "titile": "Q1", "type": "TEXT" }, { "id": 1458564606, "entry": "1109661125",...

oshliaer