What is the FormLink Letter Template Fields Reference?
This reference guide lists all the fields you can use to personalize your letter templates in FormLink. Fields act as placeholders — when a letter is generated, each field is automatically replaced with real data from your account (such as a location address, contact name, or inspection date).
To use a field, simply type its name wrapped in curly braces — for example, {City} or {InspectionDate} — anywhere in your letter template. When you generate letters, FormLink will fill in the matching information for each record automatically.
Locations Table
Field
Description
{CommonName}
Location / building name
{LocationCode}
Location code
{OccupancyClassification}
Occupancy type
{ServiceType}
Service type
{Notes}
Location notes
{Keywords}
Keywords
{LastSurveyDate}
Date of last survey
{Location_DateAdded}
Date location was added
{Address1}
Street address line 1
{Address2}
Street address line 2
{City}
City
{State}
State
{Zip}
Zip code
{StreetNumber}
Numeric street number (from Address1)
{Contact_Name}
Contact name
{Contact_Email}
Contact email
{Contact_DaytimePhone}
Contact daytime phone
{Contact_MobilePhone}
Contact mobile phone
{Contact_EveningPhone}
Contact evening phone
{Contact_Address1}
Contact address line 1
{Contact_Address2}
Contact address line 2
{Contact_City}
Contact city
{Contact_State}
Contact state
{Contact_Zip}
Contact zip
{EmailProfileName}
Email profile assigned to location
Submissions Table
Field
Description
{InspectionDate}
Date of inspection
{SubmissionDate}
Date submitted
{ScheduleFrequency}
Inspection frequency (human-readable)
{WorkOrder}
Work order number
{Inspector_Name}
Inspector name
{Inspector_License}
Inspector license number
{Inspector_Email}
Inspector email
{Company_Name}
Inspection company name
{Company_Address1}
Company address line 1
{Company_Address2}
Company address line 2
{Company_City}
Company city
{Company_State}
Company state
{Company_Zip}
Company zip
{Company_Phone}
Company phone
{Company_Email}
Company email
{Company_Fax}
Company fax
{Invalid}
Whether submission is invalid
{InvalidReason}
Reason for invalid flag
Devices Table
Field
Description
{Type}
Device / assembly type
{SubType}
Device sub-type
{Description}
Device description
{SerialNumber}
Serial number
{Manufacturer}
Manufacturer
{Model}
Model
{Size}
Size
{NextDueDate}
Next due date
{NextFrequency}
Next scheduled frequency
{ScheduledFrequencies}
All scheduled frequencies
{DeficiencyCount}
Number of open deficiencies
{EarliestDueDate}
Earliest next due date (aggregate)
{Device_DateAdded}
Date device was added
{IsRemoved}
Whether device is removed
{IsScheduled}
Whether device is scheduled
{IsInactive}
Whether device is inactive
Companies Table
Field
Description
{Company_Name}
Company name
{Company_Address1}
Address line 1
{Company_Address2}
Address line 2
{Company_City}
City
{Company_State}
State
{Company_Zip}
Zip
{Company_Phone}
Phone
{Company_Fax}
Fax
{Company_Email}
Email
{FormLinkId}
FormLink company ID
{IsAuthorized}
Whether company is authorized
Jurisdictions Table
Field
Description
{Jurisdiction_Name}
Jurisdiction name
{Jurisdiction_Phone}
Phone
{Jurisdiction_Address1}
Address line 1
{Jurisdiction_Address2}
Address line 2
{Jurisdiction_City}
City
{Jurisdiction_State}
State
{Jurisdiction_Zip}
Zip
Service Brands Table
Field
Description
{ServiceBrand_Name}
Service brand name
{ServiceBrand_Phone}
Phone
{ServiceBrand_Address1}
Address line 1
{ServiceBrand_Address2}
Address line 2
{ServiceBrand_City}
City
{ServiceBrand_State}
State
{ServiceBrand_Zip}
Zip
Gauges Table(requires Companies column in query)
Field
Description
{Gauge_Manufacturer}
Manufacturer
{Gauge_Model}
Model
{Gauge_SerialNumber}
Serial number
{Gauge_LastCalDate}
Last calibration date
{Gauge_NextCalDate}
Next calibration date
Inspectors Table(requires Companies column in query)
Field
Description
{Inspector_Name}
Inspector name
{Inspector_License}
License number
{Inspector_LicenseExpiration}
License expiration date
Fire Extinguishers Table
Field
Description
{Tag}
Extinguisher tag
{Zone}
Zone
{Location}
Location description
{Serial}
Serial number
{Manufacturer}
Manufacturer
{ManufactureDate}
Manufacture date
{Model}
Model
{Type}
Type
{Size}
Size
{Weight}
Weight
{LastServiceYear}
Last service year
{LastServiceType}
Last service type
{NextServiceYear}
Next service year
{NextServiceType}
Next service type
Deficiencies Table
Field
Description
{Deficiency_Description}
Deficiency description
{CreatedOn}
Date created
{ClosedOn}
Date closed
{DueOn}
Due date
{Resolution}
Resolution notes
{Severity}
Severity level
Work Orders / Scheduler
Field
Description
{Title}
Work order title
{OrderNumber}
Order number
{StartDate}
Start date
{EndDate}
End date
{CompletedOn}
Completion date
{CreatedByUser}
Created by (username)
{CompletedByUser}
Completed by (username)
{Status}
Work order status
{TimeOfWork}
Time of work
{Billed}
Billing flag
{Comments}
Comments
Special Macro Tags
These work without a matching query column and expand to rich content or images.
Tag
Description
{Date:MM/dd/yyyy}
Current date — use any .NET date format specifier, e.g. {Date:MMMM d, yyyy}
{PageBreak}
Inserts a page break between letter records
{Logo} or {Logo:height=80px}
District organization logo image. Optional height parameter.
{Jurisdiction_Logo} or {Jurisdiction_Logo:height=80px}
Jurisdiction logo image. Optional height parameter.
{ServiceBrand_Logo} or {ServiceBrand_Logo:height=80px}
Service brand logo image. Optional height parameter.
{Deficiencies}
Expands to a formatted table of all open deficiencies for the location. Requires a Locations column in the query.
{Devices}
Expands to a list of all devices at the location. Requires a Locations column in the query.
{Devices:Wet System,Dry System}
Devices filtered to specified types (comma-separated).
{Devices:OVERDUE_ONLY}
Only devices past their next due date.
{Devices:Wet System,OVERDUE_ONLY}
Specific device types that are overdue.
{Gauges}
Expands to a list of all gauges for the company. Requires a Companies column in the query.
{Gauges:12/31/2025}
Gauges with calibration expiring before the specified date.
{Inspectors}
Expands to a list of all inspectors for the company. Requires a Companies column in the query.
{Inspectors:12/31/2025}
Inspectors whose license expires on or after the specified date.
{IncludeForms}
Appends full inspection form PDFs for each row. Requires a Locations column in the query.