Demo 7 - Student certificate

• The teacher wants to create a certificate for students.

• The teacher needs to make several individual certificates with the same template.

1. Prepare Certificate template

2. Configuring Setup

3. Configure the Dynamic Fields

4. Publish Document

5. Submitting data in the Form

6. Submitted Data stored in Google Sheet instantaneously

7. Deliver documents

8. View Form Responses

• The teacher first prepares a Student template in Google Slide.

• Can add dynamic fields in ${field} format

Note: Click on Make a copy to get your own copy of the template and modify as per your need 

• 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 off Always ask Google login before publishing in Publish settings.

• 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

• Customize the Email Template as required.

• So once a document has submitted an email with the generated PDF will be attached to the email and sent to the student.

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

1. Open the "Fillable Slide" 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 slide.

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

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

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

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

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