Managing the Question DB
⚠️ Important update to instructions posted August 30, 2021.
- 1.Login to Google Drive.
- 2.
- 3.Create your own copy of the spreadsheet by selecting
File > Make a copy.... - 4.Now publish your copy of the spreadsheet by selecting
File > Publish to the web... - 5.Choose the Comma-separated value option as shown below.
- 6.Click the
Publishbutton and copy the full link provided.⚠️ If you are using your school Google account, ensure that you turn off restricting access to your school. If you are using a personal Google account your published link should work fine without needing to do this.
- 7.Find the setup() function in your JavaScript file, like the example below, and replace your link as the
googleSheetLink. - 8.Now you can edit your Google Sheet and your question database will automatically be updated in your trivia app.
//Runs once at the beginning
function setup() {
var googleSheetLink = "https://docs.google.com/spreadsheets/d/e/2PACX-1vRYCi4KENeZMlf9JbV8BhVrdOHse2250INSiRo7gEYWUYp3V0jiWFKWcnm1jzx5q1BMsmd9fOopk2Z_/pub?output=csv";
trivia.loadGoogleSheet(googleSheetLink).then(displayWelcome);
}
Last modified 2yr ago