Apps Script & Java Script

Testing unpublished add-on

Installable triggers and unpublished add-ons As described in Setting up onChange trigger and When test add-ons doesn’t work you can’t install a trigger in test mode. The solution is to use your add-on as a library to a container […]

Apps Script & Java Script

Setting up onChange trigger

Installable change trigger Sheets has both an onEdit and an onChange trigger to detect changes in a sheet. We’ll be using the onChange trigger, which is an installable trigger. The important difference between an installable […]

Apps Script & Java Script

Reacting to push notifications

Receiving notifications Initializing the server shows how the process starts off by the Server writing something to Ephemeral exchange (see also Getting started with Ephemeral Exchange for push notification)  This is provoked from initializing the client

[…]

Apps Script & Java Script

Initializing the server

When you’re ready to start watching for changes, the server will emulate a change to get the whole ball rolling. Here’s the Server.init code, which will provoke a push back to the client with the […]

Apps Script & Java Script

Convert field of view to zoom and back again

This is a snippet from the series described in Playing around with maps and streetview, and shows the calculation to convert between fov and zoom Objective The Streetmap image API uses field of view to figure […]

Apps Script & Java Script

Playing around with maps and streetview

In Sheets and Maps collaboration with cache – effex demo, I showed how you might use a loosely coupled app to enrich data in various platforms which used the Ephemeral Exchange store to collaborate. It’s always fun to […]

Apps Script & Java Script

Merging data with a slides template

There are a few tutorials out there about how to use replaceAllText with a Slides template in order to generate a deck where placeholder values are replaced with values with a data set. The problem […]

Apps Script & Java Script

Ephemeral exchange JSON editor and viewer

The Ephemeral Exchange Console allows you to create, read and edit JSON data directly in the store. This makes it a great too for checking data for apps that need to read or write JSON data. As […]

Apps Script & Java Script

Examining the data

Since all the data for A gigantic pub crawl is held in Efx cache, we can look at it from anywhere that has a client SDK or can make an HTTP request. Let’s start by using the […]

Apps Script & Java Script

Controlling the demo

With a system with many moving parts, we need a way to see progress and to control the behavior as we go. For that I’m using  A google sheet to display results so far A […]

Apps Script & Java Script

A gigantic pub crawl

  I wanted to put together a gigantic demo to show (and test)  the push notification capability of Ephemeral Exchange to orchestrate many things across many platforms. We’ll be linking up all these things, with the orchestration […]

Apps Script & Java Script

Pushing changes from Google Sheets server to client

Detecting changes from an add-on sidebar or dialog You’ll find various techniques for this around this site, but they are all based on polling. This means that the client app running in the browser occasionally […]

Apps Script & Java Script

VBA library for Ephemeral exchange

The REST API interface is pretty straightforward, but it is JSON. VBA doesn’t natively support JSON, but this library includes cJobect , which deals with all of that for you. This packages all the things you can […]

Apps Script & Java Script

Migrating from App Engine to Cloud functions

 Ephemeral exchange has gone serverless (for what this means see Going serverless with Firebase), and has a new home.  What’s changed The back end is completely different, but the front end interface is pretty much the same […]

Apps Script & Java Script

Ephemeral Exchange

Sometime you need to exchange transient data between platforms, but they don’t talk to each other very well. For example you could be launching a webapp with some data generated from Excel, but you want […]