How to Use WPS Find Reference Field on macOS

Use WPS Find Reference Field on macOS with 2 how-to topics; both are available without membership, and you can complete field creation and field setup from the index below.

How-to Index

How-to Guide

1. Create a Find Reference Field

Entry: Right side of the table header → “+” button → “Find Reference Field”

1. Click the “+” button on the right side of the table header.
2. Select “Find Reference Field” from the field type list.
3. Enter a field name.
4. Click “OK” to finish creating the field.

Success Criteria

• Interface result: A new Find Reference Field column appears in the data table.
• What you can do next: You can open field settings and continue configuring the reference rules.

Tips While Using

• Use a field name that matches the business meaning for easier identification later.
• You can still adjust field settings after the field is created.

2. Configure Find Reference Field settings

Entry: Right-click the field title → “Field Settings”

1. Right-click the field title.
2. Select “Field Settings.”
3. Choose the related field in the settings panel.
4. Configure the target field to display and the lookup conditions.
5. Click “OK” to save the configuration.

Success Criteria

• Interface result: The field displays matching values from the related data table.
• What you can do next: After related records change, you can continue checking whether the displayed result updates as expected.

Tips While Using

• The related field and target field need to come from an available data table structure.
• Changing field types may affect how existing data is displayed.