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 […]
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, […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
I’ve been looking at the Mozilla Open Badges initiative lately, as a way to improve engagement with a particular site or Blog. My idea is that you could assign a set of earnable badges to a […]
bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines