Tables: Sort rows

Use this action to order the rows in a data table by values in a column. This action can sort various column types, like integer, decimal, text, date, and more.

Use case

This action is the easiest way to sort a data table by column values.

  • Sort an employee table by last name
  • Sort all upcoming meetings by date
  • Sort all deals by size

How to configure this action

This action will sort rows based on the row type. At this time, the action can sort up to 100,000 rows. A integer column is sorted numerically, and a text column is sorted alphabetically鈥攖his action should sort tables predictably.

The examples below explain some unique cases. The illustration shows an example 1-column table as an input and how it would be sorted in descending or ascending order based on the column type at the top.

screen readers look here
  • Integers in integer columns are sorted in numerical order.
  • Integers in text columns are sorted as text in alphabetical order.
  • Dates and date times in a date column are sorted in chronological order, independently: Date times are ordered chronologically, then dates are ordered chronologically.

Generally, blank cells or cells that do not match the column type will be treated as empty and left unsorted and the bottom of the table.

Fields for this action

  • Data table

    • Select a table from a list of all tables available on your team. The list only includes tables you have permission to view.
      • You can also reference a table stored in a field. Change the left hand drop-down to Field then select from any field that is part of the process. Learn more.
      • If necessary, you can enter the Table ID directly. Change the left hand drop-down to ID then enter the ID manually. Learn more.
  • Data table

    • Select a table to sort rows of from a list of all tables available on your team. The list only includes tables you have permission to view.
      • You can also reference a table stored in a field. Change the left hand drop-down to Field then select from any field that is part of the process. Learn more.
      • If necessary, you can enter the Table ID directly. Change the left hand drop-down to ID then enter the ID manually. Learn more.

      馃挕Tip: This table will not be edited or overwritten.

  • Sort column

    • Name of the column to sort by. All rows will be sorted based on the column and column type.
    • Cells that do not match the column type will be treated as empty and left unsorted and the bottom of the table.
  • Sort order

    • Leave blank or enter ASC to sort in ascending order. Enter DESC to sort in descending order.
  • Output field name

    • The name of the field in which the sorted table should be saved.
    • To help keep output fields organized, this will also be added to the beginning of all other output fields.

What will this output?

This action outputs a new sorted data table to a field. The field name is the Output field name defined during configuration. The original table is not edited by this action.

At this time, the action can sort a data table of up 100,000 rows. Any table with more than 100,000 rows will be partially sorted up to this limit and the excess rows will not be included.

This action may generate multiple fields. To help keep output fields organized, the output field name above will be added to the beginning of each other output field, separated by two dashes. Each field will result as:{{output-field-prefix--output-field}}.

Output fields for this action

  • Output field name

    • The sorted data table.
  • Max

    • The maximum value in the sorted column.
  • Min

    • The minimum value in the sorted column.
  • Count

    • The count of cells in the column that contain values. This number will exclude empty cells.
  • Status

    • Returns if the sort was partial or complete.

Get help with a problem or question

If something鈥檚 not working as expected, or you鈥檙e looking for suggestions, check through the options below.

Why do some column names not work?

Enclose individual column names and values in quotation marks (""), if they contain special characters like commas, leading/trailing whitespace, and newlines. For example:

  • If the column name is $Weekly Report,,,, enter the column name as "$Weekly Report,,,", with quotation marks.
  • If you want to use the field reference {{tablecolumn}} to dynamically reference the column name, enter it as "{{tablecolumn}}"

If the column name contains a quotation mark, escape each quotation mark with quotation marks, for example: if the column name is "Column name", enter it as """Column name""".