Feature Summary
The two-way link field establishes a bidirectional association between the current sheet and a target sheet, generating linked fields in both sheets simultaneously. It is suitable for scenarios requiring bidirectional synchronized referencing and mutual viewing.
Feature Description
| Feature Dimension | Description |
|---|---|
| Membership Restriction | No membership restriction |
| Version Restriction | No version restriction |
Steps
Create a Field
Feature Entry
「Right side of header」→「+」button →「Two-way link」option
- Click the 「+」 button on the right side of the header
- In the field type list, select the corresponding field type
- Select the data table to be associated
- Enter the field name and click 「OK」 to complete creation
Link All Records
Feature Entry
Right-click「Field header」→「Field settings」→ Linkable record range →「All records」option
- Right-click the field header of this field and select 「Field settings」
- Select the data table to be associated
- In the settings panel, find Linkable record range
- Select the 「All records」 option
- Check the 「Allow linking multiple records」 option
- After completing the settings, click OK to save the configuration
Link Specific Records
Feature Entry
Right-click「Field header」→「Field settings」→ Linkable record range →「Specific records」option
- Right-click the field header of this field and select 「Field settings」
- Select the data table to be associated
- In the settings panel, find Linkable record range
- Select the 「Specific records」 option, then Select Records meeting conditions: You can set association conditions to link only records that meet the criteria
- Set "Fields Displayed When Selecting Records"
- Check the 「Allow linking multiple records」 option
- After completing the settings, click OK to save the configuration
FAQ
Q1: Does a two-way link occupy two field columns?
- Solution: Yes, a two-way link generates one linked field in the current sheet and one in the target sheet. If you only need one-way referencing, it is recommended to use a one-way link to save field space.
Notes
- After a two-way link field is created, related parameters can be modified in field settings
- Please note that changing the field type may affect the display format of existing data
- This field supports use with lookup & reference and statistics fields