Calculated Custom Fields
The ability to create a custom field which is calculated from other fields. Such as currency multiplied by a certain rate, or two multipliers in line items to give the price.
3 comments
-
As part of the Process Engine feature (due this year) we intend to allow scripts to run when records are saved: such scripts can set or calculate field values during the save process.
-
Keith Evans
commented
Hi Bola,
This idea is slightly different to what you suggest in your comment. Would you please be kind enough to log a separate idea, titled something like:
"Configurable Sequence / Customisable Pattern algorithm for generation of Object References & Custom Fields".This idea refers to read-only views e.g. you could set up a column that calculates the gross margin by performing some maths on unit price and unit cost etc.
Many thanks,
Keith -
Bola Odunlami
commented
This will be useful for my client as they would like to generate unique identifiers based on the record detail. eg [RegionCode]+[IDENTITY NUMBER]+[EmployeeInitials]
gives something like ***-36000-BAG