4 posts tagged with “templates”

Build Prefilled Form Url

A Google Form with fields you already know from a sheet row — name, email, client id — and a recipient who shouldn't have to retype them…

Fill Doc Template

A Doc full of {{Client}} and {{Amount}} placeholders, a sheet row with those headers, and a Drive folder for the finished copies…

Fill Html Template

Building approval emails and HtmlService notices by concatenating strings is how < in a client name becomes a broken page — or worse…

Escape HTML for HtmlService

Stuffing sheet values straight into HtmlService HTML is how < in a client name breaks the sidebar — or worse, opens an XSS footgun…