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 readingTag Archives: javascript
How to use Google App Scripts to send HTML emails from Google Sheets with Airtable Data
Whew!!! That is a long title! Also, 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 […]
Continue readingProgramatically retrieving data from a website into a database
Summary: Our client wanted to extract data from a web portal. We wrote a VBA script to the requested information and store it in an Access database. The example below demonstrates the same technology, but the data is stored in Excel. Edit: 7/23/2017 – An improvement on this solution. Edit: 9/9/2016 – I posted a download […]
Continue reading