How to Use WPS One-Way Linked Fields on macOS

Use WPS One-Way Linked Fields with 3 how-to topics; all 3 are available without membership, and you can start from the index below.

How-to Index

How-to Guide

1. Create a linked field

Entry: Click the + button on the right side of the table header, then choose Link to Current Table Field or Link to Another Table Field

1. Click the + button on the right side of the table header.
2. In the field type list, select Link to Current Table Field or Link to Another Table Field.
3. Enter a field name.
4. Click OK to finish.

Success Criteria

• Interface result: A new linked field column appears in the table.
• Next action available: You can open field settings and continue configuring the target table and linking method.

Tips While Using

• Common mistake: Choosing the wrong field type changes the later setup path, so confirm whether you need the current table or another table before creating the field.
• Environment note: If you plan to link another table, make sure the target table is accessible first.

2. Manually link one-way records

Entry: Right-click the field title, choose Field Settings, and select the target table

1. Right-click the field title and choose Field Settings.
2. Select the target table you want to link.
3. Set the linking method to Manual Linking.
4. Adjust the record scope and decide whether multiple linked records are allowed.
5. Click OK to save the settings.
6. Click inside a cell and choose the record you want to link.

Success Criteria

• Interface result: The selected linked record appears in the cell.
• Next action available: You can change linked records later or adjust the field settings again.

Tips While Using

• Common mistake: If the target table is not selected first, the rest of the linking setup cannot be completed.
• Environment note: Records in the target table must be visible under your current account permissions.

3. Set up auto-matching for one-way linked records

Entry: Right-click the field title, choose Field Settings, select the target table, and switch to Auto Match

1. Right-click the field title and choose Field Settings.
2. Select the target table you want to link.
3. Set the linking method to Auto Match.
4. Configure the matching conditions.
5. Click OK to save the settings.
6. Review whether matching records have been linked automatically.

Success Criteria

• Interface result: Matching records show linked results automatically.
• Next action available: You can refine the matching conditions and check the results again.

Tips While Using

• Common mistake: Conditions that are too broad or too narrow can affect the matching result.
• Environment note: Auto-matching depends on matching data being available in the target table.