This token is replaced by a column value from the first record found of a particular type. It is intended to be used with a settings record, where there will only be one instance of that settings record present

A first token is composed of the first keyword, then logical name of the entity, then the column to include. As with field tokens, the column part may also be prefixed with lookup information if it should be taken from a record linked through a lookup

Example tokens are shown below

String column in settings record

[first jmcg_settings jmcg_abn]

Replaced with the value of a column named jmcg_abn from the record in a settings table named jmcg_settings

String column in record related by lookup from settings record

<a href=”mailto:[first jmcg_settings jmcg_customerservicequeueid.emailaddress]” >Contact Us</a>

Display an email hyperlink with the email of a queue referenced by the jmcg_settings records lookup column named jmcg_customerservicequeueid

String column in settings record (URL example)

<a href=”[first jmcg_settings jmcg_instancebaseurl ]/main.aspx?pagetype=entityrecord&etn=incident&id=[incidentid]” >Open Case</a>

Displays a hyperlink to open the source case. Assumes the only jmcg_settings record has a column jmcg_instancebaseurl populated with the instances base URL