Calculated Fields

The Calculated Fields solution is an add-on for the Dataverse platform that simplifies the configuration of auto-populated column data. The solution can be installed through app source here with a free trial.

With this solution, configuring column values is made easy by using configuration records. This eliminates the need for developers to write complex business rules, workflows, or plugins to populate and maintain values. The software also removes many limitations and complexities of OOTB configuration options.

The solution is a standalone product with no external dependencies and can be installed and configured on any OOTB or customized Dataverse instance. The solution supports a wide range of calculation types including:

  1. Add Time
  2. Child Autonumber
  3. Concatenate
  4. Field Modified By
  5. Field Modified On
  6. Lookup
  7. Lookup Clone Related
  8. Lookup Event
  9. Math Expression
  10. Previous Value
  11. Rollup Fields (Count, Exists, First, Separated Strings & Sum)
  12. State Transition
  13. Switch Conditions
  14. Time Taken

As well as the calculation processes triggered by transactional changes to data, The solution also provides a useful recalculate feature which will process through all records in the system to ensure they are accurate for a new or modified calculate field record

For details of the recalculate feature click here