NickBurrows nickburrows

開啟一個空白試算表檔案 (或現有的一個試算表檔案也可以)
點擊選單列「擴充功能 > Apps Script」
幫這份檔案取個名字
在 原始碼.gs 的檔案中貼上以下代碼
儲存檔案
回到試算表
在儲存格中輸入 =SPREADSHEETNAME()、=SHEETNAME()、=ALLSHEETNAMES()

SPREADSHEETNAME 顯示目前所使用的試算表名稱

在Alfred搜尋關鍵字，開啟App Store並搜尋該關鍵字

Open Alfred Preferences
Go to Features
Click Add Custom Search
"Search URL": macappstore://ax.search.itunes.apple.com/WebObjects/MZSearch.woa/wa/search?q={query}
Mac App Store logo
Define the "keyword", like mas.
Save

在MacOS上安裝及設定aria2開機啟動

透過Homebrew安裝aria2

# 先更新一下
brew update

# 安裝aria2
brew install aria2

Home Automation – Enable SSH on Home Assistant

原文

As part of Day 18 of my 100 Days of Learning I wanted to upgrade my Home Assistant setup to run from an external SSD. There is a well known issue that SD cards on Raspberry Pis corrupt after a while and also I didn’t want Home Assistant to fill up the SD card too quickly.

I am running Home Assistant on a Raspberry Pi 3B and I would like to be able to SSH into it. By default the Home Assistant OS does not have SSH enabled and you need to install an add-on to be able to do this.

MacOS 鍵盤

符號代表的特定按鍵

Command（或 Cmd）鍵 ⌘
Shift 鍵 ⇧
Option（或 Alt）鍵 ⌥
Control（或 Ctrl）鍵 ⌃
Caps Lock 鍵 ⇪
Return 鍵 ↵

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

The frozen rows are taken as keys for the JSON.
The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.

	[
	{
	"category": "One-handed weapons",
	"image": "https://www.zeldadungeon.net/wiki/images/thumb/5/58/Bokoblin_Arm_-_TotK_icon.png/144px-Bokoblin_Arm_-_TotK_icon.png",
	"name": "波克布林之骨",
	"base_power": "20",
	"shown": "",
	"base_shield_guard": "",
	"base_durability": "5",
	"range": ""

	/*
	! tailwindcss v3.2.4 \| MIT License \| https://tailwindcss.com
	*/

	/*
	1. Prevent padding and border from affecting element width. (https://github.com/mozdevs/cssremedy/issues/4)
	2. Allow adding a border to an element by just adding a border-width. (https://github.com/tailwindcss/tailwindcss/pull/116)
	*/

	*,

	/* PrismJS 1.29.0 https://prismjs.com/download.html#themes=prism-okaidia&languages=markup+css+clike+javascript */
	code[class=language-],pre[class=language-]{
	color:#f8f8f2;
	background:0 0;
	text-shadow:0 1px rgba(0,0,0,.3);
	font-family:Consolas,Monaco,'Andale Mono','Ubuntu Mono',monospace;
	font-size:1em;
	text-align:left;
	white-space:pre;
	word-spacing:normal;