Copy Columns

Copy Columns

Copy Columns is a Column Magic feature that can copy the value of one column to another, including mirror columns that mirror a single item. Multiple trigger types are provided for copying mirrors, special columns, or local columns - or the value of the column that changed.
Custom automations are not supported due to limitations of the platform. We intend to add limited support, but it will not include mirrors, subitems, nor will it check to ensure column types are compatible.

Supported Column Types

Mirror Columns

Mirror columns are supported for most types, as both a source and destination.
Copying from a mirror copies the first items value, except number columns which copies the visible value of the column. Copying to a mirror, only the first connected item is copied to. There are plans to improve this situation in a future release.
It is not possible at this time to trigger copies of changes in mirror columns. Though you may be able to work around it with certain built-in automation templates.

Special Columns

A number of column types cannot be selected with a normal column selection, such as Name, Creation Log, Last Updated, Item ID, and Integration columns. There are special templates for copying "special columns".
Integration columns are a special type used by some integrations such as Salesforce to store a unique ID. These columns cannot be modified once written to, but we can copy them because sometimes they contain email addresses or similar. Support varies by integration.


Copying columns on subitems is limited to automation templates with the "when column changes" trigger at this time. 
There are additional triggers supported for subitems that were recently added by and we intend to implement support for them in the future.
    • Related Articles

    • Text Builder

      Text Builder is a Column Magic feature that allows you to build the value of a column from the values of other columns. Supported Output Columns You are able to build and write a text pattern to the following column types: Item name Text Column Long ...
    • Write Text Pattern to Column / Name

      Action ...write text pattern to column ...write text pattern to item name Templates When item created... When status changes to something... When column changes... When button clicked... Use actions in the custom automation builder to support ...
    • Write Text Patterns to Email

      See Write Text Patterns to Column for the basic of using a Text Builder action. These advanced actions allow you to create Actions ...write email address and email name to email column Templates When status changes to something... Use actions in the ...
    • Write Text Patterns to Link

      See Write Text Patterns to Column for the basic of using a Text Builder action. These advanced actions allow you to create Actions ...write URL Pattern and text pattern to link column Templates When button clicked... When status changes to ...
    • Copy Linked Columns

      BETA ACTION - this action is still in beta and is subject to change or replacement with newer versions. This action is only recommended for power users due to the requirement for using "developer mode" to get column IDs. Currently Copy Linked Columns ...