Dynamic Values

Dynamic values let you insert values like date and time at runtime.

KEEP IN MIND: Time and date dynamic values are counted for the locale and time zone you select in spreadsheet.

Year

Inserts current year as four digit number. Examples: 2020

Month

Inserts current month number without leading zero. Examples: 2, 10

When option Append zero is selected resulting number has always two digits. Examples: 02, 10

Month Name

Inserts name of current month for selected locale. Examples: May

You can select capitalization where only the first letter is capitalized (May), all letters are uppercase (MAY) or lowercase (may).

Day

Inserts current day number without leading zero. Examples: 2, 29

When option Append zero is selected resulting number has always two digits. Examples: 02, 29

Day Name

Inserts name of current day for selected locale. Examples: Monday

You can select capitalization where only the first letter is capitalized (Monday), all letters are uppercase (MONDAY) or lowercase (monday).

Hour (12 hour clock)

Insert current hour. 12 hour clock format. Examples: 1, 11, 3

When option Append zero is selected resulting number has always two digits. Examples: 01, 11, 03

Hour (24 hour clock)

Insert current hour. 24 hour clock format. Examples: 1, 11, 15

When option Append zero is selected resulting number has always two digits. Examples: 01, 11, 15

Minute

Inserts current minute. Example: 9, 59

When option Append zero is selected resulting number has always two digits. Examples: 09, 59

Second

Inserts current second. Example: 9, 59

When option Append zero is selected resulting number has always two digits. Examples: 09, 59

Milliseconds Since 1970

Inserts milliseconds since 1970. Example: 1589313710561

AM/PM Indicator

Inserts AM/PM indicator. Example: AM

You can select capitalization where only the first letter is capitalized (Am), all letters are uppercase (AM) or lowercase (am).

UUID

Inserts universally unique identifier (version 4). Example: a92e0180-6f00-4d00-85b9-4c45ce02a8e6

You can select capitalization where only the first letter is capitalized, all letters are uppercase or lowercase.

User Email

Inserts email address of the current user. Example: john.doe@acme.org

You can select capitalization where only the first letter is capitalized, all letters are uppercase or lowercase.

Date and Time Patterns

With this approach where each part of date or time is independent from each other you can construct any pattern you need. For example, let's have following merge fields in a draft:

• • {{year}}

  • {{month}

  • {{day}}

  • {{month_name}}

  • {{day_name}}

  • {{hour}}

  • {{ampm}}

With mappings:

• • {{year}} => Dynamic Value (Year)

  • {{month}} => Dynamic Value (Month) + append zero

  • {{day}} => Dynamic Value (Day) + append zero

  • {{month_name}} => Dynamic Value (Month Name) + first letter uppercase

  • {{day_name}} => Dynamic Value (Day Name) + first letter uppercase

  • {{hour}} => Dynamic Value (Hour 12 hour clock)

  • {{ampm}} => Dynamic Value (AM/PM indicator) + uppercase

You can construct any date format you want in template draft just surround the merge fields with characters you want. Let's say right now is May 12 2020 08:00:00 and use some common date patterns:

• • {{day}}.{{month}}.{{year}} => 12.05.2020

  • {{month}}/{{day}}/{{year}} => 05/12/2020

  • {{month}}-{{day}}-{{year}} => 05-12-2020

  • {{year}}{{month}}{{day}} => 20200512

  • {{month_name}} {{day}}, {{year}} => May 12, 2020

  • {{day_name}}, {{month_name}} {{day}}, {{year}} => Tuesday, May 12, 2020

  • {{day_name}}, {{month_name}} {{day}}, {{year}} {{hour}}{{ampm}} => Tuesday, May 12, 2020 8AM