Hello out there web friend.

My name is Jeff.

Thanks for connecting.

Lessons Learned Designing DynamoDB Tables and Queries

June 3, 2020 | Posted in AWS,DynamoDB

Over the last couple of weeks, there has been some renewed interest in a project I started a few years back, our Online@VCU virtual assistant (aka chatbot), that is created using Amazon Lex, Lambda, and DynamoDB. We launched the chatbot with maybe 10-15 intents, mostly focused on prospective and current students, but as a part […]

Read More

Open Letter Maker with Google Forms, Docs, and Apps Script

May 18, 2020 | Posted in Google Apps Script

I’ve had a few people ask me about variations to my write-up of how to auto-populate Google Docs from Google Forms submissions. One of the most recurring involves appending all responses to a single doc instead of creating a new one from a template. Does anyone have a better method than manually updating a Google […]

Read More

Delegating Client-Side Requests with google.script.run in Google Apps Script

May 9, 2020 | Posted in Google Apps Script,TypeScript

This should be a quick post, but I’m doing more of my Google Apps Script development in clasp using TypeScript now, which exposes some interesting ways of doing things that I’ll continue to document as time allows. As much as I appreciate the built-in script editor, the cognitive overload of even moderate software with a […]

Read More

Creating Headless WordPress Apps with Vue

April 24, 2020 | Posted in Vue,WordPress

Over the past several years, I’ve been prying more and more at the limits of the WordPress REST API as they apply to creating ‘headless’ sites and applications. Using the ‘headless’ methodology we can side-step server side rendering (SSR) in favor of JavaScript applications that request data as needed to re-render different views for the […]

Read More

Using Emoji in Google Sheets Formulas

April 13, 2020 | Posted in Google Sheets

I’m working on a project right now that allows people to send images to the Google Cloud Vision API for analysis using a Google Sheet and Google Apps Script. As part of that project, we talked about how we could incorporate emoji into the analysis in various ways to produce insights. Since this is also […]

Read More

ES6 Features for Google Apps Script: Arrow Functions

February 12, 2020 | Posted in Google Apps Script,JavaScript

In the second part of this series, we’re going to take a look at arrow functions, how they are used, and how they can be helpful in the context of Google Apps Script. In part one, we looked at ES6 template literals and how they can be used to create elegant and dynamic strings of […]

Read More

ES 6 Features for Google Apps Script: Template Literals

February 7, 2020 | Posted in Google Apps Script,JavaScript

Google recently announced that it is bringing the V8 JavaScript runtime to the Google Apps Script environment, and the community, myself included, reacted with much enthusiasm. This is amazing! https://t.co/Qmbb0MIugx — Jeff Everhart (@J_Everhart383) February 6, 2020 There are a lot of things to be excited about with this new change, but I also realized […]

Read More

Get Pages Using a Specific Page Template in WordPress

January 27, 2020 | Posted in WordPress

In a recent project, I had the need to get an array of all of the pages on a site that were using a particular page template. It turns out that this is really just an extension of any other type of meta query I could run, but you need to know that the meta […]

Read More

Debugging in Google Apps Script

January 24, 2020 | Posted in Google Apps Script

Most of the comments I get on this site have to do with someone trying something I’ve written about that isn’t working for them. In most cases, error messages can be your friends since they can point to the particular place your script failed and give you additional insight into why it failed. This post […]

Read More

String Interpolation in PHP

November 21, 2019 | Posted in PHP

Most of what I write about on the site exists to save someone else from having to learn the painful lessons I’ve spent time, energy, or emotion solving. This is one of those times where I’m sharing something uber useful that many people familiar with PHP may already know. As JavaScript has evolved, one of […]

Read More