Skip to content

Calculated Fields

It's possible to create a custom not-storable read-only field a value of which will be calculated dynamically upon fetching from the database.

Create a file custom/Espo/Custom/Resources/metadata/entityDefs/YourEntityType.json:

{
    "fields": {
        "yourCustomField": {
            "type": "float",
            "notStorable": true,
            "readOnly": true,
            "select": {
                "select": "SUB:(field1, field2)"
            }
        }
    }
}

SUB:(field1, field2) is a complex expression. In this example the expression substracts one field from another.

Clear cache.

You will be able to set a label for your new field at Administration > Label Manager or manually in i18n files.