Column types

Data tables support columns of the following data types:

Short text

A single-line text field. Supports a maximum of 756 characters.

Long text

A multi-line text area. Supports a maximum of 10,000 (ten thousand) characters.

Integer

Any whole number.

Decimal

Any number.

Boolean

A true/false value.

Date

Values in Date format (day/month/year).

DateTime

Values in DateTime format (day/month/year) and (hours/minutes).

File

Upload or download files to/from your data tables.

Maximum file size:

100MB

Link to a table

Display data from a different data table in your workspace.

Linked data table

Select another data table to link to your current table.

Display data from

Choose a column from the data table you have selected. Workato displays the data from this column as a dropdown. Table Storage supports linking short text and long text column types.

---

Available operands

This is a list of available operands you can use to filter your data table, based on column data type:

Short text

Available operands:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Long text

Available operands:

• Equals
• Is not equal to
• Starts with
• Is null
• Is not null

Integer

Available operands:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Decimal

Available operands:

• Equals
• Is not equal to
• Is less than
• Is greater than
• Is less or equals
• Is greater or equals
• Is null
• Is not null

Boolean

Available operands:

• Is true
• Is false
• Is null
• Is not null

Date

Available operands:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

DateTime

Available operands:

• Equals
• Is not equal to
• Is before
• Is after
• Is on or before
• Is on or after
• Is null
• Is not null

Link to a table

Available operands:

• Equals
• Is not equal to
• In
• Is null
• Is not null

File

Available operands:

• Equals
• Is not equal to
• Is null
• Is not null