22 posts found
A How-To Guide for Dealing with EDGAR's Oddities
Hello, yes I’d like to speak to the (developer experience) manager! 🤬 ☝️That was me a few weeks ago when I first tried using the SEC API. I’ve integrated with a lot of APIs over the years, but none...
A Star Wars Themed Knowledge Graph Generator with Neo4j & JavaScript
Knowledge graphs are powerful tools to visualize and explore your data, and can help uncover new insights and patterns in how your data is related. They are easy to search and navigate, but getting...
A guide for Reddit OAuth2 flow and refresh token using Apps Script and Google Sheets
Reddit offers several different options for integrating web apps, scripts, and installed apps. Just go to https://www.reddit.com/prefs/apps/ to create a new app and select the type. In this guide,...
Dealing with 405 Method Not Allowed Errors and 302 Redirects
Google Apps Scripts is incredible for a free product. There are so many things you can automate using script triggers and Google Sheets, Gmail, Docs, Calendar, and the rest of the Google ecosystem....
A Star Trek Themed Editor Inspired by Obsidian
Markdown is used widely in programming, documentation, content creation, GitHub, and lots of other areas in tech. One of the most popular Markdown editors is Obsidian, a note taking app with an...
A year-long journey of creating weekly tutorial content and key insights for content creators
Just over a year ago, I had no real experience in recording video tutorials, or in the editing or distribution process. I had experimented with a few, but never consistently, and I had no idea what I...
A Timer-driven Inbox Defender Against Spam
I get a LOT of spam email that make it passed Google’s spam detection, and I’m constantly marking emails as spam and blocking senders. It’s a never-ending battle. Most of them end with something...
Easily extract all images from a doc and sync with matching folder
Adding images to a Google Doc is no problem, but getting them back out can be a pain. I’ve written about this before with Five Ways to Extract All Images From a Google Doc, and more recently, with...
Web Viewer solution for constructing JSON from ExecuteSQL
Recently I needed to upload some data from a local FileMaker database to a REST API as part of a migration. FileMaker’s Insert from Url script step uses curl requests for sending data to another API,...
Using OrgChart JavaScript Library In A Web App
Organizational charts help visualize the reporting structure of a company in a tree-like graph. They are usually created with a design tool, and lots of manual data entry. Then, every time an employee...
A Web Viewer for Building Web Viewers
Web Viewers in FileMaker Pro are like an escape hatch. When you hit the limits of the native FMP platform, you can always extend it with a web viewer to add new functionality. You can add some really...
A primer on natural language processing with JavaScript
Lexical density measures word frequency within text. That sentence had a lexical density of 100%, but it's a little hard to understand. Let's unpack it. Lexical density, in the context of text...
Visualizing Aggregate Data Across Geographic Regions
Choropleth maps are similar to heat maps, but with regions defined by geometry, rather than a grid. These maps are useful for displaying aggregate values for each region, like census or voting totals,...
Custom Background Image With Markers Plotted From Sheets Data
Google Maps has a ton of features for plotting points on a map, but what if you want to plot points on an image? These XY Image Plot maps are commonly used for floor maps, job site inspections, and...
Interactive Heatmap in under 100 lines of code!
Heatmaps are a great way to visualize aggregate data so you can easily see trends and spikes in the data. They can summarize data across a range of time, display traffic and weather patterns, or any...
Adding custom chart types to Google Sheets using MermaidJS and Apps Script sidebars
Google Sheets has a ton of different chart types built-in, but there are a few types missing like Class, Sequence and Sankey diagrams, to name a few. When it comes to these types of charts, you...
Web Viewer Trick to Display Records in a Grid, with Click Events!
FileMaker Pro's layout design tools are top-notch. Between Form View, List View, Sub-Summary Parts, and Table View, you can build just about any type of UI you want... EXCEPT Grid Layouts! Yes, there...
A simple Apps Script web app for saving cloud-hosted files to Google Drive via API
I just found an old script I wrote that others might find useful, so I wanted to share. This script saves a file to Google Drive when you POST its URL to the webapp, using this format: { 'key':...
A collection of JavaScript and REGEX examples for common validation patterns
Hey, Joseph from GreenFlux, LLC here. I'm a full-time freelancer and a HUGE fan of Appsmith ! I've written a few other tutorials for Appsmith before but this one is gonna be a little...
General purpose Apps Script web app for saving cloud-hosted files to Google Drive
In this tutorial, I'll be writing a general purpose Apps Script Web App to save a cloud-hosted file to Google Drive as a new file, when the original file url is POST-ed to the script's web app...
Publishing script as a web app to serve as API endpoint
I've been having a lot of fun building with Appsmith lately and wanted to do something with Google Contacts. It's easy to connect to a new API from Appsmith, but it's not so easy to enable the Google...
Beginner Apps Script tutorial
Apps Script is a powerful tool for automating routine tasks with Google Sheets, Docs, Gmail, and other Google services. On a recent job, I needed to create a daily backup of a Google Sheet for a...
