How to Use WPS Department Fields on macOS

Use Department Fields with 3 how-to topics, all available without membership, and jump from the index to the steps you need.

How-to Index

How-to Guide

1. Create a department field

Entry: Data table toolbar → Field Management → Add field → choose Department as the field type

1. In the data table, click Field Management on the toolbar, or click the + button at the end of a column.
2. Enter a field name in the field settings panel.
3. Open the Field Type dropdown.
4. Under the Business category, select Department.
5. Continue with field settings as needed.
6. Click OK to finish.

Success Criteria

• Interface result: A new department field column appears in the data table.
• What you can do next: You can open field settings again or start selecting departments in cells.

Tips While Using

• Common mistake: If the field type is not changed to Department, the new field will not support department selection.
• Environment note: The organization connected to the table needs available department data.

2. Configure field settings

Entry: The settings panel while creating a department field, or right-click an existing department field header → Field Settings

1. Right-click an existing department field header.
2. Select Field Settings.
3. Turn on Allow multiple departments if one cell should store more than one department.
4. Turn on Show full department details if you want the full department path to appear.
5. Turn on Auto-fill department if new records should use the current user's department automatically.
6. Save the settings and return to the data table.

Success Criteria

• Interface result: The option states in field settings are updated.
• What you can do next: You can return to the table and enter or review department data with the new settings.

Tips While Using

• Common mistake: Auto-fill department affects new records after the setting is enabled.
• Environment note: Full department details and auto-fill depend on available organization structure data.

3. Fill in department information

Entry: Click a cell in the department field column

1. Click a cell in the department field column.
2. Browse the organization tree in the department picker panel.
3. Select the target department.
4. Confirm the selection so the cell shows the chosen department name.
5. If Allow multiple departments is enabled, continue selecting additional departments.

Success Criteria

• Interface result: The cell shows the selected department name or multiple selected departments.
• What you can do next: You can continue filtering, grouping, or editing the record.

Tips While Using

• Common mistake: If multiple selection is not enabled, one cell keeps only one department.
• Environment note: When the organization structure changes, the selection list updates with it.