Form Publisher uses Google Docs templates (Docs, Sheets, and Slides) and the data collected with the Google form to generate a custom document every time someone submits a leave request. You can use the document template for leave requests that we have made available here.
To customize each generated document, you need to include markers in the document template. Markers are placeholder keywords which are surrounded by angle brackets.
You add markers in the template document to:
- match a question in the form or to
- match standard data generated by Form Publisher
Examples of standard data are the timestamp of the form submission (date and time at which the form was submitted) and the consecutive number of the form submission (first time, second time the form is submitted).
As such, markers can be question markers and standard markers.
A question marker must exactly match the question title in the form (including uppercase and lowercase letters). For example, to match the responses in the Full name question, you add the marker <<Full name>>.
The leave request template includes the following question markers:
- <<Full name>>
- <<Team>>
- <<Manager>>
- <<Email>>
- <<Type of leave>>
- <<Start date>>
- <<End date>>
Standard markers include a specific list of keywords which Form Publisher matches to the data it records for each form submission. The leave request template includes the following standard markers:
- <<Timestamp>>
- <<Increment>>
Procedure
- Open the template Google document for leave requests.
- Click USE TEMPLATE.
Result
The template document for leave requests is now saved in your Google Drive.
What's next
Start Form Publisher and configure it to use the leave request template for the generated documents.