*Any*digital Garden of random notes

^{Table of Contents}

---

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"

Google Chrome #

chrome://settings/syncSetup/advanced #

Customize sync:

• History OFF
• Tabs OFF
• Pwds OFF
• Addresses OFF
• Payments OFF

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: /us/app/snapsee…
2. Go to Tools > Expand
3. Voila!

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

/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 #

• gif.ski = /ImageOptim/gifski

svg => png #

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

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

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

Discord #

How to Link a Channel Across Different Servers (Advanced) #

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 #

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.