Placeholders can be used in labels and tooltips to reference properties of cells or ancestors, including the properties of the diagram. The vars URL parameter can also be used to set global placeholders in a diagram. To enable placeholders, check the Placeholders option in the metadata dialog. To open that dialog, select the cell and click Edit, Edit Metadata (Ctrl+M). If no cell is selected, the diagram metadata dialog is shown which does not have a Placeholders option because it has no label or tooltip.

To reference a property in a label or tooltip, place the name of the property between % signs. For example, if a cell or one of its ancestors or the diagram have a property called name, it can be referenced in the label or tooltip using %name%. The following label contains %group% which is defined as blue and redin the respective circle. The placeholder is updated as the cell is moved between the circles:

In this example, the subnet is a variable so that all IP addresses in the subnet can be changed with a single change to the metadata:

The above diagram is available here.

To print some text between % signs without it being replaced, use two % signs. For example, %%name% prints %name% even if a property called name exists. If a cell and ancestor have a common property, the value of the cell's property is used. Likewise, if multiple ancestors have a common property, the value of the nearest ancestor's property is used.

In addition to property names, the following placeholders are available:

  • %date%: Prints the current date using the system locale.
  • %time%: Prints the current time using the system locale.
  • %timestamp%: Prints a timestamp using the system locale.
  • %date{format}%: Prints a timestamp using a custom format.
  • %pagenumber%: Prints the pagenumber of the current page.
  • %page%: Prints the title of the current page.


Placeholder


A special field called "placeholder" in the metadata of a cell can be used to reference the value under the given name in the cell's or an ancestor's metadata. This value will be used as the cell's label and updated when the label is changed. Here is an example.

If a cell or an ancestor have a property called date, time or timestamp, that property is used instead. %label% and %tooltip% are reserved names and are ignored.

Custom formats for timestamps (eg. %date{dddd, mmmm d, yyyy}%) are defined as follows:

Mask
Description
d
Day of the month as digits; no leading zero for single-digit days.
dd
Day of the month as digits; leading zero for single-digit days.
ddd
Day of the week as a three-letter abbreviation.
dddd
Day of the week as its full name.
m
Month as digits; no leading zero for single-digit months.
mm
Month as digits; leading zero for single-digit months.
mmm
Month as a three-letter abbreviation.
mmmm
Month as its full name.
yy
Year as last two digits; leading zero for years less than 10.
yyyy
Year represented by four digits.
h
Hours; no leading zero for single-digit hours (12-hour clock).
hh
Hours; leading zero for single-digit hours (12-hour clock).
H
Hours; no leading zero for single-digit hours (24-hour clock).
HH
Hours; leading zero for single-digit hours (24-hour clock).
M
Minutes; no leading zero for single-digit minutes.
Uppercase M unlike CF timeFormat's m to avoid conflict with months.
MM
Minutes; leading zero for single-digit minutes.
Uppercase MM unlike CF timeFormat's mm to avoid conflict with months.
s
Seconds; no leading zero for single-digit seconds.
ss
Seconds; leading zero for single-digit seconds.
lorL
Milliseconds. l gives 3 digits. L gives 2 digits.
t
Lowercase, single-character time marker string: a or p.
No equivalent in CF.
tt
Lowercase, two-character time marker string: am or pm.
No equivalent in CF.
T
Uppercase, single-character time marker string: A or P.
Uppercase T unlike CF's t to allow for user-specified casing.
TT
Uppercase, two-character time marker string: AM or PM.
Uppercase TT unlike CF's tt to allow for user-specified casing.
Z
US timezone abbreviation, e.g. EST or MDT. With non-US timezones or in the Opera browser, the GMT/UTC offset is returned, e.g. GMT-0500
No equivalent in CF.
o
GMT/UTC timezone offset, e.g. -0500 or +0230.
No equivalent in CF.
S
The date's ordinal suffix (st, nd, rd, or th). Works well with d.
No equivalent in CF.
'…'or"…"
Literal character sequence. Surrounding quotes are removed.
No equivalent in CF.
UTC:
Must be the first four characters of the mask. Converts the date from local time to UTC/GMT/Zulu time before applying the mask. The "UTC:" prefix is removed.
No equivalent in CF.

And here are the named masks provided by default:

Name
Mask
Example
default
ddd mmm dd yyyy HH:MM:ss
Sat Jun 09 2007 17:46:21
shortDate
m/d/yy
6/9/07
mediumDate
mmm d, yyyy
Jun 9, 2007
longDate
mmmm d, yyyy
June 9, 2007
fullDate
dddd, mmmm d, yyyy
Saturday, June 9, 2007
shortTime
h:MM TT
5:46 PM
mediumTime
h:MM:ss TT
5:46:21 PM
longTime
h:MM:ss TT Z
5:46:21 PM EST
isoDate
yyyy-mm-dd
2007-06-09
isoTime
HH:MM:ss
17:46:21
isoDateTime
yyyy-mm-dd'T'HH:MM:ss
2007-06-09T17:46:21
isoUtcDateTime
UTC:yyyy-mm-dd'T'HH:MM:ss'Z'
2007-06-09T22:46:21Z

Full and short names for days and months are currently only available in English.