This is a webapp that touches on a number of different Apps Script capabilities such as..
- The app structure
- OAuth2, and multiple providers and roles
- Firebase authentication
- Firebase to manage player data
- Using libraries to serve up client-side code, and sharing code between client and server
- Using promises in Apps Script
- Execution API and BigQuery
- People API and personalization
- Material design
- Loading large JSON datasets into BigQuery with Apps Script
- Configurable circular timer with D3
- Example of clock using d3 configurable timer
- Quick doughnut and pie charts with a radial timer
- Big quiz score reports
What does it do ?
Using data derived from mostly all the Jeopardy questions ever, served up by the ExecutionAPI using the bigquery json api, this keeps player data in Firebase, and uses the People JSON API to identify the player’s details. Questions are served up based on selected categories, and players scores are updated depending on whether they answer a question in time.
Try the App here.
I found the data here, on reddit.
A screenshot
If you want to try it, here’s the link. I’ll be writing up each of the components if you would like to see how to do this kind of app yourself.
Subpages
- Big quiz score reports
- BigQuery and the Execution API
- Configurable circular timer with D3
- Example of clock using d3 configurable timer
- Firebase custom authentication with goa
- Firebase JSON REST access library for Apps Script
- Quick doughnut and pie charts with a radial timer
- Sharing code between client and server and using libraries with html service
- Using the People API with Apps Script