Tables: Add a Row

Use this action to add a row of data to a Catalytic data table.

Use case

This action is commonly used to add data from each Workflow instance back into a Workflow’s master data table. For example, this action could add a new row to an employee data table for each new hire.

Since data tables can be available team wide, this action can add rows to data tables used by other Workflow’s or teams. This means the data can be available in other automation.

How to configure this action

This action adds values to a row of a table, but depending on the type of data in the table columns and rows, each field may need specific formatting for specific field types.

  • File fields display as a hyperlink for downloading that file
  • Date fields display in the format: YYYY-MM-DD (ex. 2018-02-14)
  • Date & Time fields display in the format: YYYY-MM-DDTHH:MM:SS.sssZ (ex. 2018-02-14T03:45:200Z)
  • True or False fields display in lowercase
  • Choose Multiple fields display as a comma-delimited list with one space after each comma
  • Columns not referenced or containing an empty value display as (none)

See the field types article for more information on field types.

✅   Heads-up: If a column name has special characters, or you’re referencing a column with a field reference, wrap it in quotation marks (""). See Why do some column names not work?.

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 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.
  • Columns

    • Input all column names where data should be populated in a comma-delimited list. Only define the columns to populate with new data.
      • Example: Fruit,Price,Quantity,Product ID
    • If a column name is a field reference or has any special characters, enclose the column names in quotation marks.
  • Values

    • Input the column values for the columns defined above in a comma-delimited list that matches the order of the Columns defined above. {{field-names}} are accepted.
      • Example: Apple,"$10",5,2928. The order of these values matches the order of the columns defined above; fruit, price, quantity, then product ID.
    • If a value is a field reference or has any special characters, enclose the value in quotation marks.
  • Output Field Prefix

    • To help keep output fields organized, choose an output field prefix to add to the beginning of each output field name as this action may output more than one field.
    • The step’s name is used as the prefix by default.

What will this output?

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

The output of this action are new rows added to a data table with the configured values. The output field will list the Row ID for each row added.

Get help with a problem or question

If something’s not working as expected, or you’re 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""".

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.

Need more help?

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.