Tables: Count Rows in a Table

Use this action to save the number of rows in a data table to a field.

Use case

This action is commonly used to understand or summarize your data. For example, before outputing a table, or performing a calculation based on a table, use this action to understand how many rows there are first.

How to configure this action

This action will count rows even if rows are blank and no values are entered. Use the Tables: Apply filters or Tables: Get unique rows actions to filter the data first to ensure you count just the rows that matter.

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 Use table via 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 Use table by ID then enter the ID manually. Learn more.
  • Name of the output of this action

    • Name for the resulting field, can be used later in {{field-names}} format to reference the filtered table

What will this output?

The expected output is a field labeled by the Name of the output of this action which can be referenced using {{field-names}} format.

Sorry about that. What was the most unhelpful part?

Thanks for your feedback

We update the Help Center daily, so expect changes soon.

Link Copied

Paste this URL anywhere to link straight to the section.

If you're signed in to Catalytic Community, you can ask other users a question. You'll be redirected to Community where you can add more info.