Using Formulas in Custom Fields
Overview
Custom Fields in Personnel Manager can be configured with formulas to automatically generate values by combining data fields with text.
Formula Basics
A formula must begin with an
=character.Use
$followed by the field name to reference a field.Use the
+symbol to concatenate (combine) fields or text.
Example:
=00000+$Card_Number1+3232000
This formula outputs the card number with a prefix of 00000 and a suffix of 3232000.
Applying Formulas to Multiple Users
Formulas can also be set up in a Personnel Template’s Custom Fields, so they automatically apply to all users assigned to that template.
Available Field Names
$Card_Number1$Card_Number2$Card_Number3$Card_Number4$Card_Number5