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 […]
Scriptdb
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 […]
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 […]
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 […]
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 […]
Apps Script & Java Script
Testing the API
This is a ScriptDB API for JavaScript. The tests that are referred to in scriptDB API for JavaScript are implemented in https://storage.googleapis.com/toasty/t/gas/scriptdbapi.html. Code is below <!DOCTYPE html> <html> <head> <meta charset=”utf-8″ /> <title>scriptDB data input – ramblings.mcpher.com</title> <link […]
Apps Script & Java Script
Authenticating scriptDb JavaScript API
As per this blog post, Google Apps Script does not support CORS (cross origin resource sharing) to allow access from cross domain client apps. The API uses JSONP for GET requests to get over this, but […]
Parse
Updating ScriptDB
Writing to parse.com was fairly complex, with all the asynchronicity and limiting. Writing the workbook to scriptDB should be much easier. We’ll use exactly the same approach as for Updating parse.com , namely get the data, get the existing […]
From VBA to Google Apps Script
Generate an auto incrementing key with scriptDB
NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. Sometimes you need to create a unique identification for each object. ScriptDB automatically assigns a unique objectId for each object, so […]
Apps Script & Java Script
cScriptdbCom client
Here’s the arguments to the cScriptDbCom class of A VBA API for scriptDB Here’s the VBA client code for A VBA API for scriptDB And the code for many of the examples mentioned for this topic For […]
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 […]
scriptDB
Creating your own scriptDB environment
Here’s what you need. This is written from the perspective of A VBA API for scriptDB, but most of it also applies to scriptDB API for JavaScript Work your way through the material on A VBA API for […]
scriptDB
Handler for cScriptDbCom requests
The VBA API generates REST API requests from your VBA function calls, and needs a Google Apps Script handler to service those requests by communicating with the required scriptDB instance. You can have multiple handlers, […]
scriptDB
Getting started with cScriptDbCom
First of all you need to Download cDataSet.xlsm and go to the scriptDBCom module, where you’ll find various examples. Readonly, no oAuth2. To get used to the API we’ll first of all use some of my test […]
From VBA to Google Apps Script
Tracking activity with ScriptDB
NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. I leave this article here for interest.In Using scriptDB, I covered some usages of scriptDB,along with a method of siloing data […]
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 […]
Apps Script & Java Script
Store data in scriptdb
Create a module that stores some test data in a public scriptdb. In Hosting your public scriptdb you will have created a public scriptDB, Here’s how to store data in a public scriptdb. We are going to […]
Apps Script & Java Script
Hosting your public scriptdb
You will need a script to host the scriptdb that contains your public data. In the step by step guide, Delegation to Google Apps Script, you should have created a script, pubstuff and added the mcpher library. […]
Parse
Microsoft Office & VBA
A VBA API for scriptDB
UPDATE parse.com as now been closed and moved to parseplatform.org. I will update the content of this page an move the back-end to this platformis text. I like scriptDB, but in many ways I prefer […]
scriptDB
Google Apps ScriptDB
NOTE: ScriptDB is now deprecated. Please take a look at Database abstraction with google apps script for alternatives. The versatile scriptDB scriptDB is a javaScript object database for Google Apps Script project. It is a very useful feature to […]
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 […]