Who is this guide for?

Case Management Supervisors

Within Osprey’s standard documents, it is possible to use standard Word fields as well as formatting these and your Osprey merge fields in the way you want to.

The most common question we are asked is why numbers or currency fields in Osprey standard documents display with 4 decimal places. Numbers are stored in the database with 4 decimal places, but you can use the number formatting switch to display these as you wish, even including the currency symbol.

When you view the MergeField field in your document, the syntax looks like this: { MERGEFIELD  Client_name }. By adding a switch, we can customise how the document displays this information.

For example, { MERGEFIELD Client_name \*Upper} will display the client name from within Osprey and display it in upper case within the Standard Document.

Number Mergefield Switches

\# £#,##.00Displays a number as £0,000.00
\*CardTextDisplays numbers as text
(for numbers over 999,999, please follow the below guide https://support.pracctice.com/guides/converting-numbers-to-text-within-word/)

Number Mergefield Switches Examples

FormatExampleOutput
\# £#,##.00{MERGEFIELD Cost \# £#,##.00}£123,456.00
\*CardText{MERGEFIELD Cost \*CardText}One hundred

Text Mergefield Switches

\f “TEXT”Specifies the text to be inserted following the MergeField field if the field is not blank
\b “TEXT”Specifies the text to be inserted before the MergeField field if the field is not blank
\* UpperDisplays the mergefield in uppercase

Text Mergefield Switches Examples

FormatExampleOutput
\b{ MERGEFIELD Name1 }
{ MERGEFIELD Name2 \b ” and ” }
Name 2 is present =
John and Joan
Name2 is empty =
John
\f{ MERGEFIELD HouseName \f “, “}{ MERGEFIELD HouseNum }HouseName is present = The Bridges, 34
HouseName is not present = 34
\* Upper{MERGEFIELD ClientName \*Upper}JOHN SMITH

Date & Time Mergefield Switches

{QUTOE{DATE}}Inserts the date that the document was created
/@ ” “This allows the formatting of the date
Day formatsd = Displays a single-digit day,
dd = Displays a two-digit day,
ddd = shows three letter abbreviation for day of the week
dddd = displays full name of the day of the week
Month formattingM = Displays single-digit months with no leading zero
MM = Displays single-digit months with leading zero
MMM = Displays a three-letter month abbreviation.
MMMM = Displays the full month name
Year Formattingyy = Displays a two-digit year number.
yyyy = displays a four-digit year number.
Hours Formattingh = displays single-digit hours based on 12-hour clock without a leading zero.
hh = displays Single-digit hours based on 12-hour clock with a leading zero.
H = displays single-digit hour based on 24-hour clock.
HH = displays two-digit hour based on 24-hour clock.
Minute Formattingm = Displays single-digit minutes without a leading zero
mm = Displays single-digit minutes with a leading zero
AM/PMDisplays uppercase AM or PM
am/pmDisplays lowercase am or pm

Date & Time Mergefield Switches Examples

FormatExampleOutput
\@ “dd MMMM yyyy”{DATE \@ “dd MMMM yyyy”}07 April 2021
\@ “HH:mm AM/PM”{MERGEFIELD Time \@ “HH:mm AM/PM”}09:34 AM
\@ “MMM-yy”{MERGEFIELD Date \@ “MMM-yy”}Mar-21
\@ “m ‘minutes'”{MERGEFIELD Time \@ “m ‘minutes'”}6 minutes

Other Field Codes

For more help and a full list of field codes available in Microsoft Word, click here: List of field codes in Word (microsoft.com)