I’ve said it before, Airtable is amazing! Amazing good! Amazing bad! I wrote a piece several years ago title, Airtable, The Good, The Bad, and the Ugly… and I mean, really Ugly. Note: Don’t shoot me, I’m only the messenger. First… I’m an Airtable Consultant. I’ve set up and work with a number of clients that get great benefit […]
Continue readingUsing Power Automate to Run Excel VBA and Connect to a 32 bit Datasource
This was originally posted on Substack http://xcode.Substack.com Download files with code and database are included below the video Technical Specs: Sage 50 Accounting Database (32 bit Pervasive SQL) 32 bit ODBC Connector Office 365 (32 bit) Microsoft Access Database (linked to Sage 50 via ODBC) to manage ECommerce Product Data Microsoft Excel VBA (macro file […]
Continue readingHow to use Power Automate Desktop to Connect to an API, Process JSON, and Create and Post JSON
This tutorial is based on a client project. Technologies/Platforms Power Automate Desktop Orderspace.com (and API) Postman.com The screen shots & notes below accompany this video Video Step by step taking you through using Power Automate Desktop to: POST OAuth2 Client ID and Client Secret to the Orderspace identity server Retrieve an authentication token to be used for calls to the API GET (retrieve) orders, in […]
Continue readingWhat’s wrong with your Airtable database and how to fix it?
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