Tables: Maximum Data in a Column

Use this action to save the maximum value of a data table column to a field.

Use case

The Tables: Maximum Data in a Column action can find the largest value. There are many uses cases for this action, including finding the most valuable client (in terms of contract spend) or the most recent date of a request.

How to configure this action

This action will save the maximum value of different field types, like numbers or dates, and has specific behaviors for each field type:

  • If the column contains dates, the action will return the most recent date.
  • If the column contains text mixed with numbers, the action will ignore rows with text and return the maximum of the numerical values.
  • If the column contains all text, the value returned will be 0.

Fields for this action

  • Data table ID

    • 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.
  • Column name

    • The display name of the new column header, in the regular Column Header format
  • Output field name

    • Enter a name for the field in which the result should be saved

What will this output?

The maximum value from the column is returned to a field. The name of the output field will be the Output field name defined during configuration.

Output fields for this action

  • Output field name

    • The maximum value from the column.

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""".