Column Usage

A column created in a table can be used in formula columns, documents, workflow actions, and as filters in database objects (e.g., views, triggers, buttons, etc.), as well as in other database functionalities such as relations, form behavior, and table record access.

If you need to determine where a column is used, simply review the Column Usage section displayed below the Column Properties form.

To access the Column Properties form and the Column Usage section, follow these steps:

  1. Click the Setup link in the top-right corner of the window.

  2. Select the table you need.

  3. From the setup menu, choose Columns > Customize existing columns. The system will display the column list.

  4. In the column list, click on the desired column name.

Columns list

As a result, the Column Properties form will be displayed, and below this form, you will find the "Column Usage" section. In this section, you can see the names and types of objects and features where the column is used. Additionally, you can click on the name of an object or feature to locate the column in the settings of that object/feature.

Column usage

Furthermore, when you need to delete the column, the "Column Usage" section will be displayed on the "Confirm Deletion" screen. This allows you to see which objects/features may be affected after the column is deleted.

Confirm Deletion screen

To prevent errors, it is advisable to first remove the column from the listed objects/features and then proceed with the deletion.