Google Sheet shortcut to insert date time

 Ctrl + Shift + : is the keystroke to insert time.

Ctrl + ; is the keystroke to insert date.

Ctrl + Alt + Shift + : is the keystroke to insert date and time.

Is there any way to create a timestamp in a Google Spreadsheet?

Japan Demographics

Google Photos app is not uploading any picture

I can not upload any pictures to Google Photos for several weeks now, so yesterday (Sunday), I decided to poke around 

Photos 5.15.0.337400196 <- condition before troubleshooting

Space used

App 123 MB

Data 618 MB

Cache 642 MB

Total 1.38 GB

Android 10

First, I deleted data and cache and it worked for a while.

Second, I tied tricks mentioned in this article Google Photos Power Management

Battery -> Apps power Management ->Put unused apps to sleep, OFF

Battery -> Apps power Management -> Apps that wont be put to sleep, add Google Photos

Deleted data and cache

Force stop app

Launch app

It works until this article is published.

Termux moving files

After moving files using termux mv command, the update doesn't necessary propagated to Gallery application as shown bellow. 

To update it, run this command line:

am broadcast -a android.intent.action.MEDIA_SCANNER_SCAN_FILE -d /sdcard/path

It will  fix the Gallery app file list problem. 

Read: 

• ACTION_MEDIA_SCANNER_SCAN_FILE
  
• 2018-08-27 Manually trigger MediaScanner to scan files on Internal Storage on Nougat/Oreo
  
• Platform codenames, versions, API levels, and NDK releases
  

Side note: I am noticing weird behaviour, the developer page states that this intent is deprecated as of  API level 29 (Android 10), but the intent is well broadcast and act upon.

Android Text File Editor

Sometimes you just got lucky finding a good text editor on android by entering the winning search term, in this case it's: "text editor android".

I decided to use Turbo Editor, instead of QuickEdit Text Editor (which is a good text editor too), since I can search for a file in a crowded directory on before I open it on Turbo Editor.

Good read: 7 Distraction-Free Text Editors for Android Compared: Which Is Best?

Notes to self: Nothing ever work out the first time.

 A system can only be trusted after it undergoes rigorous reviews, always be skeptical about any system. Use it as if it will fail you.

SyncThing

Yep, I have been bitten before too, but it's better than nothing.

Do not use Syncthing