How to Use WPS Find Reference Field on macOS

This how-to guide covers 2 topics for WPS Find Reference Field on macOS, including creating the field and configuring field settings; use the index below to jump to each task.

How-to Index

How-to Guide

1. Create a Find Reference Field

Entry: Right side of the table header → Plus button → Find Reference Field

1. Open the multi-dimensional table you want to edit.
2. Click the plus button on the right side of the table header.
3. Select Find Reference Field from the field type list.
4. Enter a field name.
5. Click OK to finish creating the field.

Success Criteria

• Interface result: A new Find Reference Field column appears in the table.
• What you can do next: You can right-click the field title and continue to field settings.

Tips While Using

• Common mistake: If you choose another field type by mistake, add a new field again with the correct type.
• Environment note: You need permission to edit the current multi-dimensional table.

2. Configure Find Reference Field settings

Entry: Right-click the field title → Field Settings

1. Right-click the title of the Find Reference Field.
2. Select Field Settings.
3. Choose the related field in the settings panel.
4. Choose the target field and set lookup conditions as needed.
5. Click OK to save the configuration.

Success Criteria

• Interface result: After saving, the column shows referenced results from the related table.
• What you can do next: You can continue editing the settings or review the referenced data.

Tips While Using

• Common mistake: If no usable related field exists first, the reference setup may not complete as expected.
• Environment note: The displayed results depend on available data in the related table.