First Page Header in Google Doc Template Not Honoured!

When using a Google Dod template to save a PDF report the First Page Header setting is not honoured.

Also, Dates are not formatted. I have a column set to Long Date but it does not get formatted as such in the PDF

0 6 199
6 REPLIES 6

Long Date format affects the date displayed in the Detail View. To reflect that to your PDF template you can format it via expression:
<<TEXT([Date], "DDDD, MM/DD/YYYY">>
or
<<TEXT([Date], "DDDD, MMMM DD, YYYY">>
For the PDF header issue, I will chime in @phil

Theoretically, TEXT([Date]) (without the format string) should apply the columnโ€™s display formatting to the value, so the format string shouldnโ€™t be needed to get the default long date display format. I havenโ€™t tested, though.

Thanks

Excellent thanks, Iโ€™ll try that

Steve.

Does not work unless you add the format string

Perfect, thanks

Top Labels in this Space