Skip to main content

Classified Columns

A classified column hides a sensitive value, like a salary, from everyone except the people you give access to.

1. Create a classification type​

  1. In Designer, go to Maintenance → Data Classification.
  2. Under Add a classification type, type a title, such as "Financial", and click Add.
  3. Add a Description.
  4. Click Save.

2. Classify a column​

  1. Open the table in Designer and edit the column.
  2. Under Data classification, pick a type.
  3. Give access (see step 3).
  4. Save the column.
note

A classified column with no access given can't be read by anyone.

These columns can't be classified: system and default columns, secret columns, Computed and Subquery columns, and Multi-lookups.

3. Give access​

Each person or group gets three switches:

SwitchLets them…
Readsee the value
Editsee, enter, change and clear the value
Createenter the value on a new item only, without seeing it afterwards

Per column, for access on every item: under Per column, use Add a user or group.

Per row, for access only on items that name them: under Per row, use Add a User column. Per-row access is Read and Edit only, and starts once the item is saved.

For per row, pick either:

  • a User column that is classified itself, or
  • Created By.

Why the User column must be classified​

Whoever is named in the User column gets access. If anyone could edit that column, they could put their own name in it and see the value. Classifying it means only the people you give Edit on it can change who's named.

Created By doesn't need classifying, because nobody can change it. It's always whoever created the item.