Generate UUID Google Sheets
To generate a unique random key in Google Sheets, you can use built-in functions for simple IDs or Google Apps Script for more robust, permanent identifiers.
Tech Notes
This is my personal user-experience notes of using Linux Distributions, GNU softwares, scripting and Web development. The contents such as wikis, commands, codes, etc. on this page and sub pages are supposed to be used by your own consideration at your own risk. So, doing your own research and climbing learning curve is recommended. I am not responsible for anything bad happened to you or your computing system due to using any content from here.
mexii
It is simple but innovative and complicated logic. Movement is in new method by pressing Enter. The indicators in the prompt line, @ [0%]: shows the direction, @ is downward and # is upward. And 0 is movement lock off, LOCKED=0 and 1 is movement lock on, LOCKED=1. % is where input letter is to appear. In this script, the chain of variables acting like toggle and relative switches is the best.
Sway Per-window Keyboard Layout
In Sway, swaymsg -m is to monitor (watch) events. For example, swaymsg -m -t subscribe '["window"]' is to watch (monitor) window event in Sway. Sway (5), Sway-ipc (7) and swaymsg (1) man pages are to read.
mshstatus
For me, it took many years to understand trap and signal for immediate updating in status on a bar like swaybar. According to gnu bash manual, it can be understood that sleep [n] & and wait $! is key to implement mechanism of immediate trigger in status blocks. Importantly, wait $! must be right after sleep command with & for going into background, for example, sleep 9 &:
AWK Programming Language
The awk utility interprets a special-purpose programming language that makes it possible to handle simple data-reformatting jobs with just a few lines of code.
Progressive Web App (PWA)
Progressive Web Apps (PWAs) are web apps built and enhanced with modern APIs to deliver enhanced capabilities, reliability, and installability while reaching anyone, anywhere, on any device, all with a single codebase.
Image Processing for Website
Image processing became essential part of web development nowadays. It is my way of image processing in Arch Linux with following steps:
Astro Notes
JSON import type errors
When we do:
index.astro
import mpps from "../../../content/members/documents/pps-myan/pps-myan.json";
import epps from "../../../content/members/documents/pps-eng/pps-eng.json";VSCode/TS will show red underlines because:
Reset Local Repo to Match Remote Repo Exactly
At any point, you may want to completely reset your local project so it matches the remote repo exactly (discarding any local changes, extra files, etc.).