How to Use WPS Related Collection Sheet on macOS

Last updated:July 20, 2026

Use Related Collection Sheet with 3 how-to topics: create a related collection sheet, manage collected data, and edit a related collection sheet; 3 items are available without membership and 0 items are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a Related Collection SheetFree
22. Manage Collected DataFree
33. Edit a Related Collection SheetFree

How-to Guide

Entry: Collaboration tab → Related Collection Sheet

  1. Click the Collaboration tab at the top.
  2. Click Related Collection Sheet on the toolbar.
  3. In the panel on the right, choose Use header row to create a collection sheet or Link an existing collection sheet.
  4. Complete the creation or linking flow based on your needs.
  • Interface result: the Related Collection Sheet creation panel appears on the right.
  • Next action available: you can continue creating a new collection sheet or linking an existing one.
  • It is helpful to organize the header fields before creating a collection sheet from the header row.
  • Keep the network connection stable during creation and linking.

2. Manage Collected Data

Entry: Related Collection Sheet panel on the right

  1. Open the worksheet that is already linked to a collection sheet.
  2. In the Related Collection Sheet panel on the right, review the submitted records.
  3. Check whether the data has filled the corresponding worksheet columns automatically.
  4. Review submitter details and submission time as needed.

Success Criteria

  • Interface result: submitted records are visible in the side panel.
  • Next action available: you can continue filtering, organizing, or analyzing the data in the worksheet.

Tips While Using

  • If you plan to keep collecting data over time, avoid changing the linked field structure casually.
  • Before deleting records in the worksheet, confirm whether the original submitted results still need to be kept.

Entry: Collaboration tab → Related Collection Sheet

  1. Click the Collaboration tab at the top.
  2. Click Related Collection Sheet on the toolbar.
  3. In the panel on the right, click the edit icon to edit the collection sheet again.
  4. If you want to unlink it, click the more icon and complete the unlink action.
  • Interface result: you can enter the edit state or complete the unlink action.
  • Next action available: after editing, you can continue publishing and collecting data; after unlinking, the current worksheet no longer receives new submissions from that collection sheet.
  • Before unlinking, confirm whether the historical data in the current worksheet has already been backed up or organized.
  • If the linked item is an existing collection sheet, be careful not to disrupt an active submission flow while editing it.