Create spreadsheet for saving results
Do the following steps:
1) Create a a new spreadsheet (Google Sheets) in Google Drive:
Into Google Drive, press the button "New" and then select "Google Sheets":
Change the name of the new Google Sheet, "Untitled spreadsheet", with a different name, for example "Sheet1" :
2) Configure the Google Sheet in QuizFaber:
Open your quiz with QuizFaber, select: Quiz menu > Quiz Properties > tab "Saving" > click on
"Save quiz results on Web Application (with Google Drive)", then press the button
"Settings".
It will show a dialog window:
Select the item "Create a new Google web application" then press the button "Next".
It will show a dialog window:
Write the name of existing spreadsheet (in the example, Sheet1) and press the button "Configure.." ,
as in the next figure:
The default browser will be opened with the page of Google authentication:
Insert your Google email and password, Google ask you to procede. Press the button "Allow":
Copy the code that Google will give you in this window:
Back to QuizFaber, paste the code in "Access code":
After inserted the code and pressed the "OK" button, QuizFaber will configure your spreadsheet.
The operation will take several seconds, it will shown the percentage of progress:
A the end, a message will inform you that the process is terminated:
Then you pass to the next phase (2 of 3):
3) With your favorite browser, log into your Google Drive account at
http://drive.google.com, or wait that the spreadsheet
is automatically opened with your default browser.
From the Tools menu, select the item "Script editor..":
Copy and paste the code, from text area of QuizFaber dialog window into a new 'Untitled Project' within the
'Code.gs' file.
Save the "Untitled project" as "FormEntry" as shown in the next window:
From the Run menu, select "setUP":
Select "Continue" from the "Authorize Required" window:
From the "Request for Permission" pop-up window, select "Allow":
From the Publish menu, select the item "Deploy as Web app...":
It is important that the field "Who has access to app" is set to "Anyone, even anonymous":
From the "Deploy as web app window", copy the web app URL.
After copy the web application URL into the Windows clipboard (or pasted it in a
text editor like Notepad), you can return to QuizFaber and press the "next" button.
A new form (step 3) will appear, as shown in the figure below:
Paste the web application URL into the text box:
Finally, press the "Close" button.
Test the saving of quiz results creating a new HTML quiz
with QuizFaber, and open run it on your browser.