Demo 8 - Science Project

Student scenario :

  • The student needs to give presentation on science experiment

  • By using this template he/she can easily prepare a presentation on science experiment

How to automate this process with Fillable Slide

Step 1: Prepare the science experiment Template

The Student first prepares an science experiment template in Google Slide.

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

Science project

Step 2: Configure the Dynamic Fields

  • Open Fillable Slide on the prepared Google Slide Template

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

  • Click on 'Open web form'

Step 3: Configure Settings

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

  • Setup Destination spreadsheet to store the form submissions.

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

  • Setup Email Template.

Step 4: Publish Document

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

  • If you don't want to keep track of user activity (like user email) switch on Always ask Google login before publishing in Publish settings.

  • The Teacher will generate the invite link and for all invite staff by mail.

Step 5: Staff submitting data in the Form

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

Science project

Step 6: Submitted Data stored in Google Sheet instantaneously.

  • Teachers can see the submitted data in the Google sheet immediately.

Note: If you have submitted the form in the 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

Science project_config

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

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

  2. Click on "Open Form as Web App".

  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 Document" to generate the merged document.

Below is a sample screenshot for email delivery.

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

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

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