Tables: Add a Column

Use this action to insert a new column at the end of an existing data table.

Use case

Using the Tables: Add a Column action can update an existing table by adding new information in a new column. For instance, if a status field is needed to track the progress of an invoice, the Tables: Add a Column action can easily add the column to track the status.

How to configure this action

The Tables: Add a Column action will not create a second version of the table but will modify the existing table. This keeps the Data table ID constant, allowing you to continue to use the table in other instances.

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

    • The display name of the new column header.
    • 💡   Tip: Column names should not contain line breaks or non-alphanumeric characters, including but not limited to ! % & () * ;
  • Column type

    • Choose the field type of the cells added in the new column.
      • Leave blank or enter TEXT to set the column type to text.
      • Other supported options are INTEGER, DECIMAL, DATE, DATE-TIME, BOOLEAN, FILE
    • See the field types article for detailed information on each field type.
  • 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 expected output of this instance is a new column with the Column name will be added to the end of the data table specified by the Data table ID. Additionally, there will be a field {output-prefix}--New column status that will return Created when the column is successfully added.

If the column you are attempting to add has the same name as an existing column, the {output-prefix}--New column status field will display “Skipped: Column named “Column name” already exists.

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.