Tag: WordPress
-
SQL
VALUES VALUES lets you create an ad-hoc list. returns: num title 1 A 2 b 3 C It is nice to be able to make a VALUES list to pass in a list you want to filter by with a readable value and an ID for joining, then LEFT JOIN with the other tables to…
-
WooCommerce Cheatsheet
Add to cart URLs with redirects WooCommerce has a lot of powerful built in features for adding products to the cart and redirecting elsewhere afterward, but I always have a heck of a time finding them in the documentation. Here are the most useful: Redirect to to the art after adding: https://yourdomain.com/cart/?add-to-cart=25&quantity=1 Redirect to the…
-
Google Sheets Cheatsheet
MATCH To run a search and return a row number, use match() on the entire column, such as A:A. By default, match returns a relative position. Example: =INDEX(‘7/12/22′!B:B,MATCH(A3,’7/12/22′!D:D,0),0) Here I’m searching in another tab named 7/12/22 in column D for text that is in A3 in the current tab. INDEX Docs Returns the contents of…
-
Bash learnings
Bash things I always need to look up. Snippets If/then/else For loop Tools curl jq jq – command line JSON processor tr Transformations! Replacements, changing case, https://linuxhint.com/bash_tr_command/ Use | tr ‘\n’ ‘ ‘) to replace new lines with spaces. awk Awk is a command line text-processing tool. Use awk to replace a text with an…
-
Amaro
Notes I want to use something with a standard proof, like whiskey or brandy, rather than 190 proof Everclear. I want to include Black Currant I want to use herbs from our garden. What about using a sous vide or whipped cream canister to speed up the infusion? What about infusing only individual botanical mixtures…
-
Meta Dates Blocks
My first Gutenberg blocks! They output the published date and last modified date for your posts, with the option to add a label. You can see them live in action here: I used George Stephanis’s Your First Block gist as a guide instead of some of the more complex starters out there since it is…