EXAMPLE — a document template for statement-merge.gs Paste this into a new Google Doc, lay it out however you like, and put the Doc's id into the MERGE_TEMPLATE_ID script property. Everything in {{double braces}} is replaced with that submission's answer; anything else is left alone, so the wording, the logo and the layout are yours. The name inside the braces is the COLUMN HEADING in your response sheet, spelled exactly — which is usually the question as you wrote it on the form. Run logPlaceholders() once and it prints the list for this sheet, calculated columns included; copy from there rather than typing them. A placeholder that matches nothing is simply left on the page, braces and all. That is the intended behaviour: a document with {{Monthly wages}} still showing is telling you the heading does not say what you thought it said. ---------------------------------------------------------------------- Statement — {{Reference}} Submitted: {{Timestamp}} Email: {{Your email address}} Annual leave taken (days): {{No. of days of Annual Leave taken during the Current Contract}} Sickness allowance unpaid (days): {{No. of days of Sickness Allowance unpaid in the Final Wage Period}} Untaken statutory holidays (days): {{No. of days of untaken Statutory Holidays during the Current Contract}} Monthly wages (HK$): {{Monthly Wages (HK$) payable for the Current Contract}} Prepared by . This document was produced from the answers given above.