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:

graphic

Select the item "Create a new Google web application" then press the button "Next". It will show a dialog window:

graphic

Write the name of existing spreadsheet (in the example, Sheet1) and press the button "Configure.." , as in the next figure:

graphic


The default browser will be opened with the page of Google authentication:

graphic

Insert your Google email and password, Google ask you to procede. Press the button "Allow":

graphic

Copy the code that Google will give you in this window:

graphic

Back to QuizFaber, paste the code in "Access code":

graphic

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:

graphic


A the end, a message will inform you that the process is terminated:

graphic

Then you pass to the next phase (2 of 3):

graphic

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..":

graphic

Copy and paste the code, from text area of QuizFaber dialog window into a new 'Untitled Project' within the 'Code.gs' file.

graphic

Save the "Untitled project" as "FormEntry" as shown in the next window:

graphic


From the Run menu, select "setUP":

graphic

Select "Continue" from the "Authorize Required" window:

graphic

From the "Request for Permission" pop-up window, select "Allow":

graphic


From the Publish menu, select the item "Deploy as Web app...":

graphic

graphic

It is important that the field "Who has access to app" is set to "Anyone, even anonymous":

graphic

From the "Deploy as web app window", copy the web app URL.

graphic


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:

graphic

Paste the web application URL into the text box:

graphic

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.