A Formula ID is composed of constant and variable text.
Constant text displays as entered and static. Variable text is formatted text because values are drawn from the source data such as roster records or person records.
A Formula ID contains variables and constants in any combination.
Variables are predefined and specific to the source data and used to generate values from the source data using predefined text.
Variables are enclosed with curly brackets to distinguish them from constants.
For example, variable {StaffingCalendarDa} returns the date of the Roster and results in 4/22/2013.
Additionally, variables can include parameters to help define its final value. Parameters are included in the curly brackets and separated by commas.
For example, variable {FromDa,eee mmm dd yyyy} returns an auction item’s award date and results in a biddable date of: Thu Jan 01 2015.
Constants can be added before and after a variable. Spaces and double quotes are allowed as part of the constant text.
For example, variable: {FromDa,mm/dd/yyyy} {FromDa,eeee} “{SpecialDayDescs}” returns an auction item’s award date including special days and results in a biddable date of: 01/01/15 Thursday “New Years Day”.
Limitation: Text resulting from a solved Formula ID is limited to 1024 characters.