How to Use WPS Department Fields on Windows

Use WPS Department Fields on Windows with 3 how-to topics, 3 available without membership, and 0 membership-related items, then 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. In the field settings panel, enter a field name.
3. Open the Field Type dropdown.
4. Under the Business category, select Department.
5. Configure the field settings as needed.
6. Click OK to finish creating the field.

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 filling department values in cells.

Tips While Using

• If you do not see the Department type, confirm that you are working in a Smart Table data table.
• Use a clear field name so later filtering and summaries are easier to manage.

2. Configure Field Settings

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

1. Right-click the header of an existing Department field.
2. Select Field Settings.
3. Turn on Allow selecting multiple departments if one cell should store more than one department.
4. Turn on Display full department information if you want the full department path to appear in the cell.
5. Turn on Auto-fetch department if new records should fill in the current user’s department automatically.
6. Save the settings.

Success Criteria

• Interface result: The field settings take effect after you save them.
• What you can do next: Return to the table and test multiple selection, full path display, or auto-fill behavior.

Tips While Using

• Auto-fetch department mainly affects new records and does not backfill existing ones automatically.
• If your organization has departments with similar names, full department information helps distinguish them.

3. Fill Department Information

Entry: Click a cell in the Department field

1. Click the Department field cell you want to fill.
2. In the department picker panel, browse the organization tree.
3. Select the target department.
4. Confirm the selection and check the department name shown in the cell.
5. If Allow selecting multiple departments is enabled, continue selecting additional departments.

Success Criteria

• Interface result: The cell shows the selected department name or the full department path.
• What you can do next: Filter, group, or summarize records by the Department field.

Tips While Using

• If no departments are available, add or sync department data in the organization structure first.
• When multiple selection is off, each cell can store only one department.