Quiz Template

Quiz scenario

  • A Teacher wants to conduct a quiz for the students.

  • The Teacher wants to publish the quiz through email.

  • Then the students will attend the quiz and submit the answer

How to automate this process with Fillable Document

Step 1: Prepare the quiz

  • The teacher first needs to prepare a quiz template in Google Document.

  • He/She can add dynamic fields in ${field} format

2. Quiz Template

Step 2: Configure the Dynamic Fields

  • Open Fillable Document on the prepared Google Document Template.

  • Dynamic fields found in the template will be automatically identified by Fillable Document.

  • By default, the field types are text.

  • Configure different types (name, grade, mark, etc) and other configurations as required.

Step 3: Configure Settings

Go to the settings tab and configure the destination folder and spreadsheet here.

  • Setup the destination spreadsheet to store the form submissions.

  • Setup the destination folder to store the generated documents and PDFs.

  • Setup the Email Template so that the teacher can send PDFs to students with the required custom message.

Step 4: Publish Document

  • The Teacher will publish the template to his students by clicking Publish Form.

  • If you don't want to keep track of user activity (like user email) switch off Always ask Google Login before publishing.

Step 5: Staff submitting data in the Form

  • After completing the quiz select the filled quiz.

  • If the student need certificate he/she can click certificate

Important Note: You need to be signed into Google Account to see the below form.

How the published form looks?

  • Click on view score to view your quiz score.

  • Click on Download Certificate to download the certificate.

How the certificate looks like?

Fillable Quiz Score Card.pdf

Step 6: Submitted Data stored in Google Sheet instantaneously.

  • The teacher can see the submitted data in the Google sheet immediately.

Note: If you have submitted the form in previous step, you should see your submitted data here.

If you are not able to see the data you have added, then please refresh the page and try

To see the submitted records, the Teacher needs to follow the following steps below.

  1. Open the "Fillable Document" add-on from the Google Document.

  2. Click on "Open Web Form"

  3. Click on the "Form Responses" icon on the toolbar.

  4. Click on a record to select for generating the document.

5. Click on "Generate" to generate the merged document

Below is a sample generated document and screenshot for email delivery.

The Teacher can generate multiple documents based on records needed. (have a look)

Sample Generated Document

Teacher can send generated document as Email by clicking on "Send as Email"

Test Demo - 123 - destination spreadsheet

Hope you enjoyed the demo and now you can use it in practice.