value

Function -> value(param 1, param 2, param 3)

"value" function can be used to assign a static/fixed or formulaic value to an attribute. This function can be used on global and asset class specific attributes.

param 1 - This parameter can be a fixed value, condition function, lookup function or derived from a Formula, a Condition or a Lookup function.

param 2 (optional) - Which attribute is updated. This is optional. If not specified, by default the same attribute is updated on which this function is applied on

param 3 - When the function is run. Options:

  1. CREATE - Function will be run only when an asset is created
  2. UPDATE - Function will be run when an asset is created or modified

This function is run automatically in the background whenever an asset is created or updated via import, web interface or mobile app.

Example 1 - Update some value when asset is created

value(Some value, CREATE)

Example 2 - Update a formula driven value when asset is created/updated

value([$classcode]-[$attribute.Some Attribute Name], UPDATE)

Example 3 - Update some value in a specific attribute

value(Some value, $attribute.WBS Code, UPDATE)

Example 4 - Update formula driven value in a specific attribute

value([$attribute.Some Attribute Name], $attribute.WBS Code, UPDATE)

Example 5 - Update attribute based on condition

value(Condition([$attribute.Head], True, eq) ? [$sequence]: null, UPDATE)

Example 6 - Update attribute to the evaluated value of the condition

value(Condition([$attribute.Head], True, eq), UPDATE)

Example 7 - Update Lookup function driven value in a specific attribute

value(Lookup($class.class A,$attribute.attribute A,$attribute.attribute B,[$attribute.attribute C]),$attribute.attribute D,UPDATE)