Concatenating Fields

Overview

Using Custom Fields in Personnel Manager, data fields can be concatenated with other strings using formulas. 


Formula

A formula is defined when the first character in the text value is the = character. Fields can be defined using the $ character followed by the field name. Fields can be combined with other fields or text by using the + character. 

Example:

=00000+$Card_Number1+3232000

In the example above the result will be the card number with a prefix of 00000 and a numeric suffix of 3232000.

Formulas can be configured within a Personnel Template's Custom Field(s) so that the formula can apply to a group of Personnel records.


Field Names

Card_Number1

Card_Number2

Card_Number3

Card_Number4

Card_Number5



Was this article helpful?