albert jalbertbowden

How to automatically timestamp a column when a row in Google Sheets is created

Couldn't be bothered to look up the latest workout tracking app, so decided to stick to Google Sheets for now. One problem with this approach is that while it is easy on desktop GSheets to fill out a current timestamp (Command-Option-Shift-semicolon in MacOS), no such shortcut is available AFAIK in the iOS version of Google Sheets.

So I wrote a little custom function in Google Apps Script to do the following:

In an active Google Sheets spreadsheet, given a tab/sheet named myworkouts with a header named datetime, the following script updates a row's corresponding "datetime" column when a value is entered into a first column cell:

Ever wanted to delete all your likes/favorites from Twitter but only found broken/expensive tools? You are in the right place.

Go to: https://twitter.com/{username}/likes
Open the console and run the following JavaScript code:

setInterval(() => {
  for (const d of document.querySelectorAll('div[data-testid="unlike"]')) {
    d.click()
 }

Algorithmic Bias

Can biased people create unbiased algorithms?
The Week in Tech: Algorithmic Bias Is Bad. Uncovering It Is Good.
Algorithms and bias, explained
Algorithmic bias
Addressing the Biases Plaguing Algorithms
Robert Elliott Smith: Are algorithms inherently biased?
What Do We Do About the Biases in AI?
[Eliminating Racial Bias in Algorithm Development](https://healthitanalytics.com/news/eliminating-racial-bias-in-algorithm-dev

	{
	"1960":316.91,
	"1961":317.64,
	"1962":318.45,
	"1963":318.99,
	"1964":319.62,
	"1965":320.04,
	"1966":321.38,
	"1967":322.16,
	"1968":323.04,

-// This is a hack, a quick and dirty console script for RT/tweets (with replies) removal w/o API
-// To be used in: https://twitter.com/Username/with_replies
-// Set your username (without @) below (case-sensitive) to correctly trigger the right Menu
-const tweetUser = 'Username'
-// BUG, With above we still trigger Menu on some replies but relatively harmless.
-// @Hack Implement simple has() for querySelector
-const querySelectorHas = function( parent, child ){

	// go to https://twitter.com/your-username, and enter the following into the developer console:
	for(var i = 1; i < 500; i++){ // just do it a bunch
	// Un retweet
	document.getElementsByClassName("ProfileTweet-actionButtonUndo")[i].click();
	document.getElementsByClassName("js-close")[0].click();
	// Delete tweets
	document.getElementsByClassName("js-actionDelete")[i].childNodes[1].click();
	document.getElementsByClassName("delete-action")[0].click()
	}