---
title: Custom columns
description: >-
  Display institution-wide user data fields as columns in the Users table, and
  edit values per user or in bulk.
sidebar:
  order: 10
---

**Custom columns** are how institution-defined [custom data fields](/docs/fuxam-web/base/user-management/custom-data-fields) appear in the **Users** table. Each column is tied to a field definition shared across every user. Values show as table cells and on each user's **Overview** tab, so staff can search, filter, and edit supplementary directory data alongside core account information.

:::info
Custom columns are the **table display and inline-editing layer**. The underlying attributes — including requesting missing values from users — are covered in [Custom data fields](/docs/fuxam-web/base/user-management/custom-data-fields).
:::

## Why it matters

Every university maintains data that does not fit a generic user record — matriculation numbers, external system IDs, scholarship flags, advisor assignments. Without custom columns, that information lives in spreadsheets parallel to Fuxam, creating sync problems and audit gaps.

Custom columns keep supplementary data **visible in the same system of record** as user accounts. Registry staff can update a matriculation number once and see it in the table, on the profile, and during [user creation](/docs/fuxam-web/base/user-management/create-a-user). When combined with [bulk actions](/docs/fuxam-web/base/user-management/bulk-actions), you can import or correct hundreds of values after an intake without opening each profile individually.

## Key concepts

| Term | Meaning |
|---|---|
| **Custom data field** | The institution-wide attribute definition and stored value on each user. See [Custom data fields](/docs/fuxam-web/base/user-management/custom-data-fields). |
| **Custom column** | That field shown as a column in the Users table for scanning and inline editing. |
| **Field type** | Determines what values are allowed — text, number, date, single select, multiple select, or auto-generated ID. |
| **ID field** | A column that auto-generates identifiers using a configurable format pattern. |
| **Column-level access** | Some edit rights apply to a specific column rather than all custom fields institution-wide. |

### Field types

Each custom column has a type that controls validation and editing behavior:

| Type | Use for | Notes |
|---|---|---|
| **Text** | Free-form text — names, codes, notes | No format restriction beyond text. |
| **Number** | Numeric values — counts, scores | Digits only. |
| **Date** | Dates — enrollment date, expiry | Enter dates in year-month-day order (for example, 2026-09-01). |
| **Single select** | One option from a predefined list | Good for status flags with fixed values. |
| **Multiple select** | One or more options from a predefined list | Good for tags or multi-value categories. |
| **ID** | Auto-generated identifiers | Uses a configurable format pattern; can backfill existing users on creation. |

## Add a custom column

1. Go to **Campus Management → Users**.

2. Select **Add** in the toolbar, then choose **User Data Field**.

3. Configure the field name and type in the dialog.

4. Save. A new column appears at the right side of the Users table.

Alternatively, if you have column-creation access, you can add a column placeholder directly in the table header and name it inline.

:::info
You need permission to create user-management columns (institution-wide or for a specific column) to add fields. Renaming columns requires permission to update user-management columns.
:::

When you create an **ID** field with a format pattern, Fuxam can automatically generate IDs for existing users.

:::tip
Plan your column names and types before a large intake. Changing a **Single select** option list later is manageable, but switching field types after data exists can be disruptive. Use **ID** fields for matriculation numbers that must follow a strict format.
:::

## Edit column names

Select the column header text to rename a field (when you have update access). Press **Enter** or click away to save. Duplicate names are rejected.

## Edit values per user

### In the Users table

Click any cell in a custom column and enter or select a value. Changes save when you confirm or move away from the cell, depending on the field type.

For batch edits across many users, select rows and use **⋯ → Edit Custom Fields**. See [Bulk actions](/docs/fuxam-web/base/user-management/bulk-actions).

### On the user profile

Open a user's **Overview** tab. Custom fields appear in the profile sections alongside basic information. Edit and save using the unsaved-changes indicator.

See [Edit a user](/docs/fuxam-web/base/user-management/edit-a-user) for the full profile editing workflow.

## Set values when creating a user

The **Add User** form includes any configured custom fields below the standard name, email, and role inputs. Fill them in during creation if you already know the values.

This is the preferred path during intake: capture student ID, department code, or other identifiers at the moment the account is created rather than returning to fill cells later.

## Access for editing values

To change a user's custom field value you typically need **both** of the following:

- Permission to update that user (or users institution-wide), **and**
- Permission to update the specific user-management column (or columns institution-wide).

Without both, the cell or field appears read-only.

| Access | Scope | Allows |
|---|---|---|
| Create user-management columns | Institution-wide | Add new field definitions |
| Create a user-management column | Per column | Add a specific field |
| Update user-management columns | Institution-wide | Rename or configure any column |
| Update a user-management column | Per column | Edit a specific column definition or its values |
| Update users / update a user | Institution-wide / per user | Edit user records including field values |

Role configuration is covered in [Roles and permissions](/docs/fuxam-web/base/user-management/roles-and-permissions).

## Best practices

- **Define columns before intake.** Agree on names, types, and select options with registry staff before creating hundreds of accounts.
- **Use ID fields for formatted identifiers.** Matriculation numbers with a fixed prefix and sequence are less error-prone as auto-generated **ID** fields than free-text entry.
- **Keep select lists short.** **Single select** and **Multiple select** work best with stable, well-defined option sets — not free-form categories that change weekly.
- **Use bulk edit for corrections.** After a data import, filter the affected users and run **Edit Custom Fields** rather than correcting cells one by one.
- **Separate directory data from academic data.** Program enrollment and curriculum assignment belong in [Study programs and cohorts](/docs/fuxam-web/cms/programs-and-planning/study-programs-cohorts); custom columns are for supplementary directory attributes.
- **Restrict sensitive columns.** Use column-level access so only registry roles can edit identifiers like national ID numbers.
- **Request missing values when appropriate.** For incomplete profiles after intake, use [data collection requests](/docs/fuxam-web/base/user-management/custom-data-fields) instead of leaving blank table cells indefinitely.

## Common pitfalls

| Pitfall | What happens | How to avoid |
|---|---|---|
| Cell appears read-only | Missing permission to update the user or the column | Check both access layers on the role |
| Duplicate column name rejected | A field with that name already exists | Rename or reuse the existing column |
| Wrong date format | Date field rejects the value | Enter dates as year-month-day (for example, 2026-09-01) |
| ID not generated for existing users | ID field created without backfill | Configure the format pattern at creation — Fuxam can generate IDs for existing users when the field is created |
| Mixing academic and directory data | Cohort info duplicated in custom columns | Use cohorts for enrollment; custom columns for institution-specific metadata |

## FAQ

**How are custom columns different from custom data fields?**

**Custom data fields** are the underlying institution-defined attributes stored on each user. **Custom columns** are how those fields appear and are edited in the Users table. See [Custom data fields](/docs/fuxam-web/base/user-management/custom-data-fields) for requesting missing information and the full field model.

**Can I change a column type after creating it?**

The documentation describes field types at creation time. Plan types carefully before data entry begins. If you need a different type, consider creating a new column and migrating values rather than assuming an in-place type change is available.

**Do custom columns appear when exporting users?**

Custom column values are part of the user record in User Management. Use [Bulk actions](/docs/fuxam-web/base/user-management/bulk-actions) **Export Users** to include user data in exports — the export reflects the columns visible in your table view.

**Who can see custom column values?**

Anyone with permission to view users who can open the Users table or a user's **Overview** tab can see custom field values, unless your institution further restricts editing with column-level access.

**How are custom columns different from cohort assignment?**

Custom columns store arbitrary institution-defined attributes on a user profile. [Cohorts](/docs/fuxam-web/cms/programs-and-planning/study-programs-cohorts) are academic enrollment groups tied to study programs and curricula. A matriculation number belongs in a custom column; degree program enrollment belongs in a cohort.

## Related pages

**[Custom data fields](/docs/fuxam-web/base/user-management/custom-data-fields)**

Underlying profile attributes and requesting missing information.

**[Create a user](/docs/fuxam-web/base/user-management/create-a-user)**

Set custom field values during account creation.

**[Edit a user](/docs/fuxam-web/base/user-management/edit-a-user)**

Update profile fields on the Overview tab.

**[Bulk actions](/docs/fuxam-web/base/user-management/bulk-actions)**

Edit Custom Fields for many users at once.

**[Roles and permissions](/docs/fuxam-web/base/user-management/roles-and-permissions)**

Column creation and editing access per role.

**[View a user](/docs/fuxam-web/base/user-management/view-a-user)**

See custom fields on the Overview tab alongside core profile data.
