I’ve spent the past few years consulting organizations that use Airtable. I’m going to share what I consider the big issues I’ve come across, some thoughts on why these problems are nearly always present, and how you might remedy them. WHAT IS AIRTABLE? Airtable is a cloud-based, no-code/low-code, relational database system. It has gained in […]
Continue readingAdding Google Sheets to BigQuery with Google Apps Script and Running SQL Queries on Sheet Data
This tutorial and accompanying video is going to show how to programmatically use Google Apps Scripts to add Google Sheets as tables in BigQuery. It will also demonstrate and include some SQL queries run against Google Sheets data. If you have any questions, ask in the comments or use this contact form. Also, I have […]
Continue reading3 Lessons Learned Building Productivity Apps for Meta
First, if you are hoping for specific internal information about Meta, this isn’t that. Professionally driven privacy and discretion is my first responsibility. This is more an explanation of how I approached my work and interacted with customers, peers, and others in the Meta environment. There are lessons to be gleaned. I spent the better […]
Continue readingUsing Google App Scripts for contract assembly and save as PDF documents
I’ve been building complex document assembly systems since dinosaurs roamed the earth. And by dinosaurs, I mean, 286 computers running Word for DOS 4.0. This is a simple, but effective, method in Google Apps Script to generate multiple PDF contracts in a matter of seconds. I provide the code below. In this video, I go […]
Continue readingHow to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data
I don’t demonstrate pulling data from Airtable in this video or code example. If you’d like that, check out my previous article on my client’s Airtable Reporting Dashboard using Google App Scripts, BigQuery, and Google Data Studio. The code to pull Airtable data is there. However, this is a Goals vs Actuals Dashboard in use […]
Continue readingAirtable Reporting System using Google Apps Script, BigQuery, and Google Data Studio with source code
Airtable Report Dashboard Using Google Apps Script, Google Big Query, and Google Data Studio We are working to bring a few prior blog post to Achieve Data Solutions. We will not be including screen shots – though they may be added later. The video explains everything and the source code is available via the link […]
Continue reading