Carrot reference
...
Fields
Data Types
Name
a carrot datatype used by fields that store employee names the name datatype is not supported by custom fields the name datatype is currently limited to the default field name properties the name datatype supports the following properties property definition name last returns last name, ex "morrison " name first returns first name, ex "jim " name pref returns preferred first name, ex "jimmy " name preflast returns preferred last name, ex "morrison " name middle returns middle name, ex "douglas " name full returns full name name preferred returns preferred full name name preferredfirst returns preferred first name if it exists, otherwise returns first name name lastpreferred returns preferred full name, reversed, ex "morrison, jimmy " name firstlast returns full name name lastfirst returns full name, reversed, ex "morrison, jim " sample usage name last returns the last name of a record