Embedding Field Names in Other Fields or Look-up Table Entries

Embedding Field Names in Text and Lookup Table Entries

ProForm field references, prompts, and expressions may be typed into any text field or Look-up table entry. When you refer to a field name in another field, it is called embedding. An embedded field name is replaced with the actual data in that field when you merge the data file with a word processing document or print a document. The standard method of embedding a field into another field is to type the field name you want embedded in double brackets:

{{fieldname}}

Example: To embed the first buyer/borrower name, type {{BYR1NAM1}}.

Embedding Tip: Embedding field names in a generic legal description

Embedding is a useful tool to create a common legal description. Suppose you are doing several closings for a condominium project. The text in the Legal Description: field will be the same for each individual condo closing with the exception of individual pieces of information like the address. Instead of typing the same legal description over and over again for each closing, you can create a template to use with your condo closings which contains the common legal description. Embed the field names whose contents will be different with each closing into the generic legal description. Then, every time you need to do another condo closing, use the template you have created. The legal description will already be typed and the embedded fields in it will be replaced with the appropriate data when you print basic documents or use the WordPerfect / MS Word merge feature.

Using formatting options

Formatting options can be added to your field references and prompts. Type ProForm field references with options using the following format:

{{fieldname}option1 option2 ...}}

Options should be separated by a space. The following formatting options can be included in your field references and prompts:

Date Field Option	Description
MS	Month (i.e., January)
MT	Month number with suffix (i.e., 1st, 2nd, 3rd, ...12th)
M1	Month using digits 1-9 and 10-12 (i.e., 1=January, ...12=December)
M2	Month using two-digit format (01=January, ...12=December)
D1	Day using digits 1-31
D2	Day using two-digit format (01-31)
DT	Day number with suffix (i.e., 1st, 2nd, 3rd, ...12th)
Y2	Year in two-digit format (i.e., 97=1997)
Y4	Year in four-digit format (i.e., 1997)
SP	Date in Month Day, Year format (i.e., January 1, 1997)
ST	Date in Month Day (with suffix), Year format (i.e., January 1st, 1997)
SR	Date in Day (with suffix) of Month, Year format (i.e., 1st of January, 1997)

For example, if the settlement date in your file was 1/1/97, and you embedded data field reference {{settdate}SR}} into a field, 1st of January, 1997 would be inserted into that field.

Address field option	Description
CITY	City (i.e., Raleigh)
STATE2	State abbreviation (i.e., NC) entered in the Address field.
STATE	Full state name (i.e., North Carolina) spelled out from two-letter state abbreviation entered in the Address field.
SNAME	Full state name (i.e., North Carolina) spelled out from two-letter state abbreviation entered in the State field.
ZIP	Zip code.

Name field option	Description
NFIRST	First name
NMIDDLE	Middle name
NLAST	Last name
NSUFFIX	Suffix (i.e., Jr.)
NPREFIX	Prefix (i.e., Mr.)

Numeric field option	Description
NOCOMMA	Removes commas inserted by default in numbers greater than 999
WORDS	Spells out dollar amount in check format (i.e., One hundred fifty and 00/100)
WWORDS	Spells out numeric amounts (i.e., One hundred fifty)
BRAC	Puts Paid Outside of Closing amounts in brackets. For example, if the Borrower column for Line 801 contains a $1,000.00 POC amount, the field reference {{b801}brac}} would result in [1000.00].
FILL	Fills field with asterisks (for numeric amounts, i.e., $***150.00) or dashes (for numeric amounts spelled out, i.e., -----One hundred fifty and 00/100-----).
#.#	Total width of numeric field including decimals and commas. The first # represents the total width, and the second # represents the total number of decimal places. For example, 6.2 = total width of 6, including 2 decimal places.
#	Indicates total number of decimal places to include. For example, the field reference {{intrate}2}} would result in the amount in the Annual Interest Rate field printed with two decimal places.

Options available in all field references	Description
ZERO	Prints a zero (0) if the field referenced is zero or blank
N/A	Prints N/A if the field referenced is zero or blank
BLANKS	Prints blank space (_____) if the field referenced is zero or blank
UCASE	Prints text in all caps.