No Picture
Badges

jQuery plugin for image special effects

For the badges program, I needed to find a way of graying out badges already awarded to this particular user. As an aside, I am looking up whether a badge has been awarded using the Google Apps Script […]

No Picture
Badges

How to set up your own badge environment

In the various sections in Badges I showed the detail behind creating a badge environment. Now, let’s say you wanted to implement your own badge issuing environment. You can use some or all of the xLiberation environment, […]

No Picture
Badges

Protecting email addresses

I’m using Persona to handle authentication for badges. This is largely because that’s what Mozilla open badges use. However it does mean that I can avoid storing any identifiable data, even though I have to host […]

No Picture
Badges

Implementation progress

What’s going on here In Badges I described a badge manager infrastructure I was planning, centered on the Mozilla Open Badges. There a quite a lot of components involved. I’ll be showing the latest pieces I’m working on […]

No Picture
Badges

Badge component summary

Here is a summary of how all the pieces fit together Stored and referenced from scriptdb Badges – the base unit of earning Badge collections – a collection of Badges that are likely to go […]

No Picture
Badges

Qualifying for a badge

In Assigning badges to pages we looked at how to create a panel showing which badges have been earned, or could be earned, on a page. To be able to earn a badge you have to demonstrate […]

No Picture
Badges

Badges

What are badges? Check here What has openbadges to do with Excel Liberation Open badges are a great way of recognizing competence, and I’m interested in seeing whether I might be able to personalize the […]

No Picture
Badges

Creating badge environment from a spreadsheet

In Assigning badges to pages I covered what a script would look like that could generate a badge awarding environment. Typically you would create a UI to manage this, rather than doing it through scripts. However, here’s […]

No Picture
Badges

Assigning badges to pages

One of the things we need to be able to do is to assign a set of badges that can be earned on a web site, know which badges have already been earned, and allow […]

No Picture
Apps Script & Java Script

Setting up blister lists

In Using blister custom functions I showed examples of how to lookup scriptDB lists as custom functions.  Here’s how to create lists. In each case, to access lists in your sheet you need to add a reference […]

No Picture
Apps Script & Java Script

Blister validation code

Here is the code for each of the example mentioned in GAS lists and validation. The custom functions You need this in your local workbook. You can find it in the examples sheet. These are the custom […]

No Picture
Apps Script & Java Script

Using blister custom functions

Examples Let’s take an example. Say you are a small garage, with a stock list of cars and you work exclusively with spreadsheets. You don’t want to take copies of the list, but you want […]

No Picture
Apps Script & Java Script

Blister custom functions

The custom functions These are the custom functions you can call directly from your sheets. The function documentation is here and you can find examples of use in Using blister custom functions and you’ll need the code described in Blister […]

No Picture
Apps Script & Java Script

GAS lists and validation

It’s very common to want to lookup some list, or apply them as validation to data entry when playing around with Spreadsheets. Between them, a search for Spreadsheet related VLOOKUP, INDEX and MATCH return 30 […]

Apps Script & Java Script

scriptDb JavaScript api examples

The JavaScript client is very similar to A VBA API for scriptDB, so reading that will give you a more detailed flavor of what can be done. The implementation is very different though, and there are […]

From VBA to Google Apps Script

Trying out your new scriptDB environment

If you’ve followed Creating your own scriptDB environment we are ready to start accessing it from VBA. Registering authentication There are 2 things you need to do, both of which are one-off things. You may have done […]

From VBA to Google Apps Script

Using scriptDB

scriptDB is a javaScript object database for Google Apps Script project. Here are a few key facts Every project can have its own scriptDB There are no Tables (this is a noSQL database). Instead it is […]

Things that have been deprecated

This site has been around for a few years, and inevitably, some things get deprecated, or generally out of date. I’m reluctant to delete the material, because It was a lot of effort to write […]

Apps Script & Java Script

scriptDB API for JavaScript

We have CRUD natively to scriptDB from Google Apps Script, A VBA API for scriptDB gave us one for Excel – now here’s one for JavaScript. That means you can use the same noSQL database for all […]

No Picture
Deprecated

First shot at Polymer

I’ve just completed my first Polymer app and have mixed feeling about the experience. Regulars to this blog and the associated site know that I’m a great fan of Google stuff and like to try out […]