If you're a Fusion user, this feature is not available in the Components or Drawings workspaces. Learn more about system workspaces.
Computed fields are Item Detail fields that automatically calculate values based on formulas you define. They update in real time as data changes and can include custom UI elements using HTML. Along with appearing in Item Details, computed fields can also be used in workspace views and reports.
Computed fields can help you:
Computed fields support a wide variety of basic capabilities:
COST_1 + COST_2
WHEN (MEASURED_WEIGHT > WEIGHT)
or WHEN (CONFIRMED is FALSE)
LENGTH|| ' mm '
CASE WHEN (PRIORITY is null) THEN ‘?’ WHEN (PRIORITY = 1) THEN 'Low', WHEN (PRIORITY = 2) THEN ‘Medium’, ELSE ‘High'
WHEN(PRIORITY is not null)
Computed fields also support a wide variety of advanced capabilities:
ROUND(CONFIRMED_EFFORT - PLANNED_EFFORT, 0)
coalesce(LABOUR_COST,0)
CAST(COST as FLOAT)
DATE_PART('day', CURRENT_DATE – LAST_MODIFICATION_DATE)
WHEN LENGTH(TITLE) < 10 THEN
<span style=“color:red“>High</span>
<iframe src=“www.google.com“>
<object style="width:100%;height:500px“ data="'||DRAWING_URL||'&inline&thumbnail" type="application/pdf"></object>
<img style="height:60px" src="https://yt3.ggpht.com/-JP7BQdvTP60/AAAAAAAAAAI/AAAAAAAAAAA/zvpjFigLSis/s900-c-k-no-mo-rj-c0xffffff/photo.jpg">
<a "href=www.google.com" target=“_blank“>Search</a>
For more detailed examples, refer to Examples of Computed Field Formulas
You can create a new computed field or convert an existing field into a computed one.
Be aware of these limitations when working with computed fields: