Skip to main content
Skip table of contents

Asset class attributes and workflow fields

Asset class attributes and workflow fields in Utility Cloud let you define what information is collected on an asset or during a workflow. You configure these fields in the Asset Class Builder or Workflow Class Builder, and users see them when viewing an asset or completing a workflow report.

Creating a field

To add a new field to an asset class or workflow class:

  1. Select the Asset Classes or Workflow Classes tile from the Landing Page or the navigation menu.

  2. Enter your search criteria and select the asset class or workflow class you want to edit.

  3. Select the plus icon to add a new field. If no fields have been defined yet, select No fields have been defined. Click here to add one.

  4. Enter all required settings for the field.

  5. Select Save.

The right side of the editor screen is where you configure a field's settings. The left side shows a live preview of how the field will appear when filling out the form.

Fields can be re-arranged by selecting a field and dragging it up or down.

Security Rights Required: View Asset Classes; Edit Asset Classes; OR View Workflows; Edit Workflows


General settings

Every field has the following general settings:

  • Title: The name of the field shown to you.

  • Type: The field type, which controls what kind of data you can enter. See Field types below.

  • Key: A unique identifier for the field. Keys are used to reference this field in expressions, conditional visibility rules, and conditional popup messages.

  • Description: Optional additional information displayed as help text below the field title.

  • Units: A label for the unit of measurement, such as feet, inches, or gallons.

  • Required: When checked, you must enter a value before submitting.

  • Active: When unchecked, the field is deactivated and hidden from you. Fields can't be permanently deleted in order to preserve historical data.

  • Populate value from previous workflow report: When checked, the field automatically pre-fills with the value you entered for the same field in the most recently completed workflow for this asset.

  • Default Value: A value that is pre-filled when the asset or workflow is created. You can change it if needed.

Defaulting to another field's value

To pre-fill a field's default value from another field in the same workflow, the syntax varies by field type:

  • Number fields: =KEY

  • Multiple Choice fields: [KEY]


Advanced settings

Advanced settings control conditional behavior for a field.

  • Use String Literal For Reports: Forces the field to return a string value when used in reports.

  • Visibility is Conditional: When checked, the field shows or hides based on conditions you define. See Conditional visibility below.

  • Show Conditional Popup Message: When checked, a popup message appears based on conditions you define. Conditional messages use the same syntax as conditional visibility.

Conditional visibility

Use the Visibility is Conditional setting to show or hide a field based on the value of another field. Enter the condition using one of the following formats:

Single value:
KEY=Value
Example: FLOW=Yes

Multiple values (OR logic):
KEY=1~KEY=2~KEY=3

Range or comparison:
Key1<Key2 or Key1>10

Checking if a Multiple Select field contains a value:
KEY contains VALUE
Example: COLOR contains Green

Checking if a Multiple Choice field equals a value:
KEY=VALUE
Example: COLOR=Green

The supported comparison operators are:

Operator

Meaning

=

Equal to

<>

Not equal to

>

Greater than

<

Less than

>=

Greater than or equal to

<=

Less than or equal to

contains

Contains the specified value

does not contain

Does not contain the specified value

Note: Setting a field to Hide When True will always hide it, preventing users from seeing or editing it. This is typically used for expression fields.

Note: When a field is hidden by a conditional visibility rule (other than Hide When True), any value in that field is not saved when the workflow report is submitted.


Field types

Select one of the following field types when creating a field.

Additional Report Emails

Allows you to select one or more email addresses to send a copy of the completed workflow report to. The workflow must have a report associated with it for this field to send an email, and you can configure report association in the Workflow Class Builder.

You can add multiple Additional Report Emails fields to a single workflow to notify different recipients.

Assets

Allows you to select from a list of related assets. You can configure the field to show:

  • All child assets of the current asset

  • All assets in the same account as the current asset

  • All assets that are both in the same account and children of the current asset

Assets fields can be used with triggers to specify which asset receives an update in an Update Other Asset Attribute trigger, or which asset has a work order created against it in a Dynamic Work Order trigger.

Date

Validates that the entered value is a date in MM/DD/YYYY format. You can select a date from a calendar picker.

The Default Value supports the following date shortcuts:

  • A specific date. Pre-fills that date when the asset or workflow is created.

  • T - pre-fills today's date.

  • T+# - pre-fills today's date plus the specified number of days.

  • T-# - pre-fills today's date minus the specified number of days.

To add date validation, append a comma and a condition to the default value. If the entered date doesn't meet the condition, you'll see an Invalid Date message. Supported validations: >=T, <=T, >T, <T.

Example: To default to today's date and require the date to be today or earlier, enter T,<=T or T,<T+1.

Datetime

Validates that the entered value includes both a date and time in MM/DD/YYYY HH:MM – AM/PM format.

The Default Value supports:

  • A specific datetime. Pre-fills that value when the asset or workflow is created.

  • N - pre-fills the current date and time.

Email

Validates that the entered value is in a valid email address format.

Expression

Expressions calculate a value automatically based on other field values or data from previous workflows. They are configured in the Default Value box and evaluated when the workflow report is opened or updated.

Note: Expressions are only evaluated when a record is opened and saved directly in the Workflow Report Editor or Asset Editor. They don't evaluate when records are updated through triggers, imports, Esri syncs, or other automated processes. For this reason, expressions are not recommended for asset class fields.

Expression syntax rules

  • [KEY] -resolves to the current value of the workflow field with that key.

  • {TOKEN} -resolves a field key or system keyword to its numeric ID. Used when a function needs an ID rather than a value, or to reference system values like {WorkOrderID}.

  • (...) -parentheses control order of operations.

Expression functions and keywords

Function / keyword

Syntax

Description

fixed

fixed(value, decimals)

Rounds a number to the specified number of decimal places.

days

days(first, second)

Returns the number of days between two date values. If second is omitted, returns days since first.

hours

hours(first, second)

Returns the number of hours between two time or datetime values.

months

months(first, second)

Returns the number of months between two date values.

years

years(first, second)

Returns the number of years between two date values.

previous

previous({KEY})

Returns the value of a field from the most recently completed workflow report for this asset. {KEY} resolves the field key to its numeric ID.

workflow

workflow(workflowID, assetID, fieldID)

Returns the value of a specific field from any workflow on any asset. assetID is the numeric asset key visible in Utility Cloud. fieldID is the workflow form field ID or key.

trigger

trigger(fieldID)

Returns the value of a field from the workflow that triggered the current work order.

contains

contains([KEY], "value")

Returns true if the value of KEY contains the specified string. Useful for checking a value within a Multiple Select field.

{WorkOrderID}

{WorkOrderID}

Resolves to the ID of the current work order.

{TriggeringReport}

{TriggeringReport}

Resolves to the workflow report ID of the workflow that triggered the current work order.

Expression examples

Goal

Expression

Notes

Difference between two readings

([HSTot])-previous({HSTot})

HSTot is the field key for the HS Totalizer reading.

Pull a value from a field on another asset

workflow(5880, 3377854, 37494)

Parameters are: workflow ID, asset ID, workflow form field ID.

Pull a value from the asset into a workflow

[Asset.Color]

Reads the Color attribute from the current asset.

Round to a fixed number of decimal places

fixed(([HSTot])-previous({HSTot}),2)

Wraps the expression with fixed(...) and appends ,2 for 2 decimal places.

Multiply a field value

fixed([44178]*2)

44178 is the workflow form field ID.

Days between two dates

fixed(days([STARTDATE],[ENDDATE]),2)

STARTDATE and ENDDATE are Date type fields.

Hours between two times in minutes

fixed(hours([FLUSHEND],[FLUSHSTART])*60,0)

FLUSHSTART and FLUSHEND are Time type fields.

Months between two dates

fixed(months([STARTDATE],[ENDDATE]),2)

Years between two dates

fixed(years([STARTDATE],[ENDDATE]),2)

Conditional value (single option)

[TYPE]=="CB"?[CBAssetID]:"Nothing"

If TYPE equals CB, shows the value of CBAssetID. Otherwise shows "Nothing".

Conditional value (multiple options)

[TYPE]=="CB"?[CBAssetID]:[TYPE]=="DMH"?[DMHAssetID]:"Nothing"

Chain conditions using the same ternary pattern.

OR comparison returning a value

([CapUsed]>25\|\|[CapUsed2]>25?"FAIL":"PASS")

Returns FAIL if either value exceeds 25.

AND comparison returning a value

([CapUsed]>25&&[CapUsed2]>25?"FAIL":"PASS")

Returns FAIL only if both values exceed 25.

Concatenate text fields

[Fieldname1]+[Fieldname2]+[Fieldname3]

Example: "ABC"+"123"+"XYZ" → "ABC123XYZ".

Concatenate number fields as text

[Fieldname1]+""+[Fieldname2]+""+[Fieldname3]

Empty strings prevent numeric addition. Example: 123+""+444 → "123444".

Check if a field contains a value

contains([KEY],"Value 1")?"Value 1 is present":"Value 1 is not present"

Useful for Multiple Select fields.

Pull a value from the triggering workflow

trigger(50875949)

50875949 is the workflow form field ID in the triggering workflow.

Pull the triggering workflow report ID

{TriggeringReport}

Pull the current work order ID

{WorkOrderID}

Note: Workflow keys can be found in the Workflow Classes tile on the search results screen, or in the main edit panel of the Workflow Class Builder.

Heading

Displays a title with no input. Use this to separate sections of a long form.

Memo

A multi-line free-text field for longer entries.

Multiple Choice

Allows you to select one option from a dropdown list. The list options come from List Definitions. If your list isn't available, you can create it from this screen. See List definitions for more information.

Multiple Select

Allows you to select one or more options from a dropdown list. List options come from List Definitions. See List definitions for more information.

Number

Validates that the entered value is numeric. You can set the following constraints:

  • Min: The minimum allowed value.

  • Max: The maximum allowed value.

  • Step: The allowed increment (for example, 1 for whole numbers or 0.01 for two decimal places).

If the entered value doesn't meet these constraints, you'll see a validation message.

To set Min, Max, or Step dynamically from another field in the workflow, enter =KEY as the value for that constraint.

Photo

Allows you to upload a photo.

QR Code

Allows you to associate the asset with a QR code for easy identification.

Signature

Allows you to draw a signature directly on the form.

Telephone

Validates that the entered value is a 10-digit phone number in ###-###-#### format.

Text

A single-line free-text field for short entries. Accepts letters, numbers, and punctuation.

Time

Validates that the entered value is a time in HH:MM – AM/PM format.

The Default Value supports:

  • A specific time. Pre-fills that value when the asset or workflow is created.

  • N - pre-fills the current time.

True/False

Displays a checkbox. Returns true when checked and false when unchecked.

Users

Allows you to select one or more Utility Cloud users.


You can include hyperlinks in field descriptions or in the Default Value of a Text type field using the following format:

[link text|URL]

Example: Please visit [Utility Cloud|http://www.utilitycloud.us] for more information.

Description hyperlink: Appears as informational text below the field title.

Default Value hyperlink: Pre-fills in the field when the asset or workflow is created. You can change it if needed.


JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.