How to Use WPS Multidimensional Text Field on macOS

Use WPS Multidimensional Text Field with 4 how-to topics, including creating a field, setting a default value, preventing duplicate values, and entering text; 4 items are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a Text Field

Entry: Click the + button on the right side of the header row → open the field type list → select Text

1. Click the + button on the right side of the table header.
2. In the field type list, select Text.
3. Enter a field name.
4. Click OK to finish creating the field.

Success Criteria

• Interface result: A new text field column appears in the table.
• Next action available: You can open field settings or start entering content immediately.

Tips While Using

• Common mistake: If the field name is left blank, creation may not finish as expected.
• Environment note: You need edit permission for the current multidimensional table.

2. Set a Default Value

Entry: Right-click the field title → Field Settings → Default Value

1. Right-click the text field title.
2. Select Field Settings.
3. Find the Default Value option in the settings panel.
4. Enter the preset content. New records will use this value automatically.

Success Criteria

• Interface result: The field settings panel shows the saved default value.
• Next action available: When you add a new record, the field is prefilled automatically.

Tips While Using

• Common mistake: After a default value is set, new records are filled automatically, so review the content before saving if changes are needed.

3. Prevent Duplicate Values

Entry: Right-click the field title → Field Settings → Prevent Duplicate Entries

1. Right-click the text field title.
2. Select Field Settings.
3. In the settings panel, enable Prevent Duplicate Entries.
4. Save the setting. Repeated content will trigger a prompt and must be changed.

Success Criteria

• Interface result: The duplicate-prevention option is enabled in field settings.
• Next action available: If you enter the same content again, the system prompts you to revise it.

Tips While Using

• Common mistake: Check existing data before enabling this option so earlier duplicates do not affect later entry.
• Environment note: Only one text field in a table can be set to prevent duplicate values.

4. Enter Text Content

Entry: Select the target cell → type directly

1. Click the target cell in the text field column.
2. Enter text, symbols, or a long numeric identifier.
3. Press Return to confirm the entry.

Success Criteria

• Interface result: The entered content appears in the selected cell.
• Next action available: You can continue editing, copying, or adding the next record.

Tips While Using

• Common mistake: If a long numeric value needs to be used in calculations, use a numeric field instead.
• Environment note: When duplicate prevention is enabled, repeated content must be changed before it can be saved.