Dynamic ValueS

Dynamic Values are values generated automatically by AnyMerge Docs during document generation. Instead of storing these values in your spreadsheet, the add-on creates them when the documents are generated.

Dynamic Values are useful for dates, times, unique identifiers, and information about the current user.

Note: Dynamic Values use the locale and time zone configured in your Google Sheets™ spreadsheet. For example, when using the Thai locale, the year is displayed according to the Buddhist calendar.

Available Dynamic Values

Year

Inserts the current year as a four-digit number.

Examples:

2026

2569 (Thai locale)

Month

Inserts the current month number.

Examples:

6

11

Enable Append Zero to always display two digits:

06

11

Month Name

Inserts the name of the current month based on the spreadsheet locale.

Examples:

June

มิถุนายน

You can choose the capitalization style:

• Keep Letter Case

• UPPERCASE

• lowercase

Day

Inserts the current day of the month.

Examples:

9

28

Enable Append Zero to always display two digits:

09

28

Day Name

Inserts the name of the current day based on the spreadsheet locale.

Examples:

Monday

วันจันทร์

You can choose the capitalization style:

• Keep Letter Case

• UPPERCASE

• lowercase

Hour (12-Hour Clock)

Inserts the current hour using the 12-hour format.

Examples:

1

8

11

Enable Append Zero to always display two digits:

01

08

11

Hour (24-Hour Clock)

Inserts the current hour using the 24-hour format.

Examples:

1

15

23

Enable Append Zero to always display two digits:

01

15

23

Minute

Inserts the current minute.

Examples:

7

59

Enable Append Zero to always display two digits:

07

59

Second

Inserts the current second.

Examples:

4

42

Enable Append Zero to always display two digits:

04

42

Milliseconds Since 1970

Inserts the number of milliseconds since January 1, 1970 (Unix Epoch).

Example:

1770069810561

This value can be useful when generating unique filenames or identifiers.

AM/PM Indicator

Inserts the current AM/PM indicator.

Examples:

AM

PM

You can choose the capitalization style:

• Keep Letter Case

• UPPERCASE

• lowercase

UUID

Inserts a Version 4 universally unique identifier.

Example:

a92e0180-6f00-4d00-85b9-4c45ce02a8e6

You can choose the capitalization style:

• Keep Letter Case

• UPPERCASE

• lowercase

UUIDs are useful when generating unique references or tracking identifiers.

User Email

Inserts the email address of the current user.

Example:

john.doe@acme.org

You can choose the capitalization style:

• Keep Letter Case

• UPPERCASE

• lowercase

Building Date and Time Patterns

Because each date and time component is independent, you can combine Dynamic Values to create virtually any format directly in your template.

For example, consider the following merge tags:

{{year}}

{{month}}

{{day}}

{{month_name}}

{{day_name}}

{{hour}}

{{ampm}}

with the following mappings:

{{year}} → Dynamic Value (Year)

{{month}} → Dynamic Value (Month) + Append Zero

{{day}} → Dynamic Value (Day) + Append Zero

{{month_name}} → Dynamic Value (Month Name)

{{day_name}} → Dynamic Value (Day Name)

{{hour}} → Dynamic Value (Hour, 12-hour clock)

{{ampm}} → Dynamic Value (AM/PM Indicator) + UPPERCASE

You can construct any date or time pattern by surrounding the merge tags with the characters you want.

Examples:

{{day}}.{{month}}.{{year}} → 09.06.2026

{{month}}/{{day}}/{{year}} → 06/09/2026

{{month}}-{{day}}-{{year}} → 06-09-2026

{{year}}{{month}}{{day}} → 20260609

{{month_name}} {{day}}, {{year}} → June 9, 2026

{{day_name}}, {{month_name}} {{day}}, {{year}} → Tuesday, June 9, 2026

{{day_name}}, {{month_name}} {{day}}, {{year}} {{hour}}{{ampm}} → Tuesday, June 9, 2026 8AM

Dynamic Values provide a flexible way to include runtime information in your documents without adding extra columns to your spreadsheet. By combining these simple building blocks, you can create date and time formats that match your exact requirements.