Enter your search text in the box above

Select a result to preview

Tech Ground

Terminal

find . -type l -ls

# excluding folder:
find . -not -path '*/node_modules/*' -type l -ls

Check HTTP headers with curl

curl --head HTTP_URL

# or simply:
curl -I HTTP_URL

The -I flag (shorthand for --head) fetches only the HTTP headers from a server. This is the fastest way to inspect status codes, content types, and server metadata without downloading the actual page content.

JS

Delete all HTML elements by class in pure JS

document.getElementsByClassName('...').forEach(function(el){ el.parentElement.removeChild(el) })

TikTok

How to switch TikTok Business Account back to Personal

  1. Go to Settings > Security > Manage app permissions
  2. Remove Business
  3. Go to Settings > Account
  4. Switch back to Personal

How to dislike a TikTok video on web (desktop)?

There is no explicit option (like in mobile app), however you can still click "Report" > "Other" > "Not interested"

image

Google Chrome

chrome://settings/syncSetup/advanced

Customize sync:

Rely on Password Manager better.

🪲 UX Defect in Google Photos

No option to move a photo to another Album

Workaround: Add to another Album, then remove from original Album (what is very annoying)

iOS

🪄 How to expand/upscale/enlarge an image on #iOS?

Problem: built-in Photos app only allows you to crop

Solution:

  1. Install #Google’s #Snapseed: http://apps.apple.com/us/app/snapsee…
  2. Go to Tools > Expand
  3. Voila!

How to show/sync Google's "other calendars" on iOS?

https://calendar.google.com/calendar/syncselect

Very weird tho, that in 2023 you still have to do that

How to add a specific url/link/page to Home Screen on iOS

  1. Turn Airplane Mode ON
  2. Refresh the desired page (to get “Safari cannot open page…”)
  3. Share > Add to Home Screen 🪄

Weird, but works.

How Import an album to Google Photos on iOS?

  1. Open Google Photos.
  2. At the top right, tap your profile icon. Google Photos settings.
  3. Tap Apple Photos. Import albums.
  4. Select the albums that you want to import.
  5. At the top right, tap Import.

How to move contacts between accounts on iOS

  1. Go to Contacts and start dragging one
  2. Point to “< Lists” in top left corner (help by other hand while dragging)
  3. Drop to new account
  4. Delete the duplicate from “Linked Contacts” inside the contact card

macOS

svg => png

brew install librsvg
rsvg-convert -h 512 ./favicon.svg > ./favicon.png

svg => ico

brew install imagemagick
magick favicon.png -background none -define icon:auto-resize=48,64,256 favicon.ico # 256 is max!

Ever stuck with Google login window in Internet Accounts on #macOS?

Go to Preferences > General, set Default browser back to Safari and try again

image

Discord

To link a channel from Server A into a message in Server B, you need the Channel ID:

  1. Enable Developer Mode: Go to User Settings > Advanced and toggle on Developer Mode.
  2. Copy ID: Right-click the channel name (or long-press on mobile) and select Copy Channel ID.
  3. Use this Syntax: In your message, type <#CHANNEL_ID> (replacing CHANNEL_ID with the numbers you copied).

Mod ideas for Civ

• Auto-sell all resources at min price specified (practically means +50-100 gold per turn).
• Available-to-buy notifications (Great Ppl, buildings, etc).
• Finally fix NotificationsClear mod :)

Google Sheets
Ctrl + ` toggle formulas

Last text value in a column (e.g., Column A):

=LOOKUP(REPT("z",255),A:A)

REPT("z",255) creates a very long string of zs, which is alphabetically after any typical text string. LOOKUP will find the last text value.

Google Sheets shortcuts of the day (macOS)

Select row: Shift + Space
Insert row: Option + Cmd + Plus

Instant row insert: Shift + Space + Space, then Option + Cmd + Plus 🤯

🔻 Performance issue in Google Sheets

Using MATCH() inside Pivot table filters

Workaround: FILTER() the data before passing to Pivot table

🐞 Bug in Google Sheets

VALUE() function cannot parse long numbers, i.e:

=VALUE("1111111111111111") -- returns the error

🪲 UX Defect in Google Sheets

Omitting is_ascending argument will break SORT() function to work as expected

🪲 UX Defect in Google Sheets

QUERY() inside ARRAYFORMULA() not throwing any errors, however NOT SUPPORTED at all

🐞 Bug in Google Sheets

FILTER(..., ISBETWEEN(...) ) does not work well with Pivot table data

Workaround: use >= and <= combo instead of ISBETWEEN()

🐞 Bug in Google Sheets

COUNTIF() does not work well with string criterions starting with "<"

Workaround: prepend criterion with "="&

Apple Numbers

🐞 Milliseconds are NOT supported in Date cells

image

Slack

How to recover "Starred" section in #Slack (if accidentally removed)?

Workaround: Go to Slack on mobile, and move any channel back to "Starred", it will now appear on desktop too.