By Matthew E. Milliken
MEMwrites.wordpress.com
Sept. 10, 2021
More than three years ago, I set up an applet on the invaluable Web service that I still think of as If This Then That. The service, actually known as IFTTT, lets users create simple programs that run automatically.
My inelegantly titled “Log your #wordpress blog posts in Spread sheet” applet was set up no earlier than Sunday, May 13, when I wrote about the Durham County, N.C., primary election, and no later than Thursday the 17th, when I posted about updating passwords for my myriad Internet accounts.
Ever since May 17, 2018, IFTTT has faithfully logged every post on this blog on a Google Sheets spreadsheet stored on my Google Drive cloud account. I rarely refer to the spreadsheet, but the other night, I decided to take a peek and make some modifications.
The first change was easy: I inserted the label “Days since previous post” atop the fifth column. The first four columns are, in order, “Date-Time,” “Title,” “Full URL” and “Category, tags.” Then I fiddled around with some spreadsheet functions in order to convert the first column into a number.
Read the rest of this entry »
MEMwrites 