Add Reference Column

You can include a visual column that references data from another table's column.

If you want to add a column to your current table using data from another table, you can create a visual column that connects to a specific column in that other table. This can be done when both tables share a common column.

1. Go to Setup > Columns.

1. Click Add Visual Column > Add Reference Column.

1. Enter the name of your visual column. We want to include the order date, so we enter the name 'Order Date'. We can also change the type to 'Date'.

1. Let us now enter the column and table details that we want to refer to. Enter the connection details, schema name, reference table name, column to be referenced, and the column that corresponds to both current and reference tables. Click Save.

In the example below, we have referred to the 'Orderdate' column from the 'Sales' table, whose connection details we have entered.

The visual column is added to the table, and it looks as shown below:

Reference columns are non-editable and their values only change when the underlying column values change.