##Date and Time
=TIMEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " ")) + DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Date
=DATEVALUE(SUBSTITUTE("{{OccurredAt}}"," at ", " "))
##Time
robotsandcake
/ terminal-cheat-sheet.txt
Created
April 26, 2020 17:51
— forked from cferdinandi/terminal-cheat-sheet.txt
Terminal Cheat Sheet
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
| # Terminal Cheat Sheet | |
| pwd # print working directory | |
| ls # list files in directory | |
| cd # change directory | |
| ~ # home directory | |
| .. # up one directory | |
| - # previous working directory | |
| help # get help | |
| -h # get help |
robotsandcake
/ wpa_supplicant.conf
Last active
October 29, 2019 14:25
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
| country=GB | |
| update_config=1 | |
| ctrl_interface=/var/run/wpa_supplicant | |
| network={ | |
| scan_ssid=1 | |
| ssid="MyWiFiSSID" | |
| psk="S3cr3tp@$$w0rc|" | |
| } |
robotsandcake
/ applescript key combination
Created
June 14, 2019 21:23
Example of using AppleScript to invoke key combinations. This hides the application other than the from most one when.
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
| tell application "System Events" | |
| -- This key combination hides every application other than the frontmost | |
| keystroke "h" using {command down, option down} | |
| end tell |
robotsandcake
/ application_visibility.scpt
Last active
June 14, 2019 21:20
AppleScript to change visibility of given applications.
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
| tell application "System Events" | |
| -- Replace opera and VLC with the applications you want to influence | |
| -- He can have as many as you like, each one on a new line | |
| set visible of application process "Opera" to false | |
| set visible of application process "VLC" to false | |
| end tell |
robotsandcake
/ IFTTTDate.md
Created
February 7, 2019 14:15
— forked from oscarmorrison/IFTTTDate.md
Make IFTTT Date Format play nice with Google Spreadsheets
robotsandcake
/ multiple_ssh_setting.md
Created
June 8, 2018 18:50
— forked from jexchan/multiple_ssh_setting.md
Multiple SSH keys for different github accounts
create different ssh key according the article Mac Set-Up Git
$ ssh-keygen -t rsa -C "[email protected]"
robotsandcake
/ research-notes.md
Last active
May 3, 2018 17:34
Research notes for TASA: https://tasa.space/
Space officially begins according to "the man" at 100 km AGL, and is known as the [Kármán line][1]. Anything below that is not space, anything above that is space.
As the payload gets higher the [temperature will drop][2], this is due to an affect called the [adiabatic lapse rate][3]. There is no absolute measurement for this as it is affected by moisture content in the air amongst other things, but it is defined by the [International Civil Aviation Organisation][4] As:
robotsandcake
/ keybase.md
Created
January 30, 2018 15:57
I hereby claim:
- I am robotsandcake on github.
- I am robotsandcake (https://keybase.io/robotsandcake) on keybase.
- I have a public key whose fingerprint is 0E1B 42C5 2E68 2CC4 9D70 D494 AE1D CB03 6B7D E2FD
To claim this, I am signing this object:
robotsandcake
/ emojis.json
Created
December 18, 2017 11:41
— forked from oliveratgithub/emojis.json
Emoji-list with emojis, names, shortcodes, unicode and html entities [massive list]
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
| { | |
| "emojis": [ | |
| {"emoji": "👩👩👧👧", "name": "family_mothers_two_girls", "shortname": "", "unicode": "", "html": "👩‍👩‍👧‍👧", "category": "p", "order": ""}, | |
| {"emoji": "👩👩👧👦", "name": "family_mothers_children", "shortname": "", "unicode": "", "html": "👩‍👩‍👧‍👦", "category": "p", "order": ""}, | |
| {"emoji": "👩👩👦👦", "name": "family_mothers_two_boys", "shortname": "", "unicode": "", "html": "👩‍👩‍👦‍👦", "category": "p", "order": ""}, | |
| {"emoji": "👨👩👧👧", "name": "family_two_girls", "shortname": "", "unicode": "", "html": "👨‍👩‍👧‍👧", "category": "p", "order": ""}, | |
| {"emoji": "👨👩👧👦", "name": "family_children", "shortname": "", "unicode": "", "html": "👨‍👩‍👧‍👦", "category": "p", "order": ""}, | |
| {"emoji": "👨👩👦👦", "name": "family_two_biys", "shortname": "", "unicode": "", "html": "👨&zw |
robotsandcake
/ lifx_red_flash_all.applescript
Created
August 15, 2017 09:51
When run, this small piece of AppleScript will flash every LIFX lightbulb in the house red as part of an IF recipe.
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
| -- This sends an event to the Maker IFTTT channel, replace red_flash with | |
| -- whatever you like but make sure that URL is saying wherever you use it. | |
| set theURL to "https://maker.ifttt.com/trigger/red_flash_all/with/key/YOUR_SECRET_KEY" | |
| do shell script "curl " & quoted form of theURL |
NewerOlder