Demo 10 - Employee Certificate

Company Scenario :

  • The Company wants to create a appreciation certificate for employees

  • The Company HR Manager needs to make a individual certificates with same template for the employees

How to automate this process with Fillable Slide

Step 1: Prepare the Employee Certificate Template

The Hr first prepares a employee certificate template in Google Slide.

Can add dynamic fields in ${field} format

Employee certificate

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

  • And click on 'Open web form'

Step 3: Configure Settings

Go to 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

  • Teacher will publish the template to his staff by clicking Publish Form(4rd option in tab).

  • 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.

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

Step 5: Staff submitting data in the Form

  • After complete the quiz select the filled quiz

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

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

Step 6: Submitted Data stored in Google Sheet instantaneously.

  • Business Manager 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, business manager need to follow the steps below.

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

  2. Click on "Open Form as Web App"

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

  4. Click on a record to select for generating document

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

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

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

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