DJ Adams qmacro
qmacro
/ gist:4493660
Created
January 9, 2013 14:47
Whitespace at the start of an array causes the parse of that array to be erroneous. Note the space between [ and { on line 32.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| report ydj_json_test. | |
| types: | |
| begin of ty_favcolour | |
| , name type string | |
| , colour type string | |
| , end of ty_favcolour | |
| . | |
| types: |
qmacro
/ gist:5517150
Created
May 4, 2013 10:56
Deliberately step-by-step, exploring FP in Python. names.txt contains lines like this: "MARY","PATRICIA","LINDA","BARBARA"
"ELIZABETH","JENNIFER","MARIA","SUSAN","MARGARET"
"DOROTHY","LISA"
"NANCY"
"KAREN","BETTY","HELEN" etc
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| import itertools | |
| import operator | |
| print reduce( | |
| operator.add, | |
| map( | |
| lambda n: (n[0]+1) * n[1], | |
| enumerate( | |
| map( | |
| lambda name: reduce( |
qmacro
/ gist:6199968
Created
August 10, 2013 10:39
#YRS2013 Hacks On Github - code to retrieve commit counts from Github API and store in a Google spreadsheet
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // 0-indexed columns | |
| COMMITS = 3; | |
| GITHUBREPO = 2; | |
| TOKEN = ""; | |
| function main() { | |
| TOKEN = ScriptProperties.getProperty("githubtoken"); | |
| var ss = SpreadsheetApp.getActiveSpreadsheet(); | |
| var sh = ss.getSheetByName("Hacks"); |
qmacro
/ gist:6199973
Last active
October 3, 2021 20:19
SheetAsJSON - expose a Google spreadsheet (with a header row) as JSON - See https://qmacro.org/2013/10/04/sheetasjson-google-spreadsheet-data-as-json/ for a writeup
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| function doGet(request) { | |
| var output = ContentService.createTextOutput(); | |
| var data = {}; | |
| var id = request.parameters.id; | |
| var sheet = request.parameters.sheet; | |
| var ss = SpreadsheetApp.openById(id); | |
| data["records"] = readData_(ss, sheet); | |
| var callback = request.parameters.callback; | |
| if (callback == undefined) { | |
| output.setContent(JSON.stringify(data)); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE HTML> | |
| <html> | |
| <head> | |
| <meta name="description" content="demandPopin example" /> | |
| <meta http-equiv="X-UA-Compatible" content="IE=edge" /> | |
| <meta charset="UTF-8"> | |
| <title>3431071</title> | |
| <script id="sap-ui-bootstrap" |
qmacro
/ filterexample.js
Created
October 7, 2013 14:23
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| itembinding.filter( | |
| new sap.ui.model.Filter([ | |
| new sap.ui.model.Filter([ | |
| new sap.ui.model.Filter("Category", "EQ", "AC"), | |
| new sap.ui.model.Filter("Category", "EQ", "PR") | |
| ], false), | |
| new sap.ui.model.Filter([ | |
| new sap.ui.model.Filter("SupplierName", "EQ", "Red Point Stores"), | |
| new sap.ui.model.Filter("SupplierName", "EQ", "Technocom") | |
| ], false), |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html><head> | |
| <meta http-equiv='X-UA-Compatible' content='IE=edge' /> | |
| <meta http-equiv='Content-Type' content='text/html;charset=UTF-8'/> | |
| <title>test</title> | |
| <script id='sap-ui-bootstrap' type='text/javascript' | |
| src='https://sapui5.hana.ondemand.com/sdk/resources/sap-ui-core.js' | |
| data-sap-ui-theme='sap_bluecrystal' | |
| data-sap-ui-libs='sap.m'></script> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CALENDAR = "Work"; | |
| EVENT_MATCH = /^SAP\s/; | |
| GUEST_LIST = ['you-1@example.com', 'you-2@example.com']; | |
| DATE_FROM = new Date('01 Jan 2014'); | |
| DATE_TO = new Date('31 Dec 2014'); | |
| FORCE_ADD = false; | |
| function main() { | |
| inviteMe(CALENDAR, DATE_FROM, DATE_TO, EVENT_MATCH, GUEST_LIST, FORCE_ADD); | |
| } |
qmacro
/ CheckboxColumnBinding.html
Created
February 4, 2014 08:34
Checkbox and Column Visibility binding
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE HTML> | |
| <html> | |
| <head> | |
| <meta http-equiv="X-UA-Compatible" content="IE=edge" /> | |
| <meta charset="UTF-8"> | |
| <title>Checkbox and Column Binding</title> | |
| <script id="sap-ui-bootstrap" | |
| type="text/javascript" |
qmacro
/ 0_reuse_code.js
Created
March 9, 2014 18:17
Here are some things you can do with Gists in GistBox.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Use Gists to store code you would like to remember later on | |
| console.log(window); // log the "window" object to the console |