How to Use WPS Multidimensional Text Field on Windows

Use WPS Multidimensional Text Field with 4 how-to topics, including creating a text 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 path: Click the + button on the right side of the table header → 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.

Success Criteria

• Interface result: A new text field column appears in the table.
• What you can do next: You can enter text or open field settings.

Tips While Using

• Common mistake: If the field name is too general, later identification and maintenance may become harder.
• Environment note: You need edit permission for the current multidimensional table.

2. Set a Default Value

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

1. Right-click the target text field title.
2. Select Field Settings.
3. Find the Default Value option in the settings panel.
4. Enter the preset content.
5. Save the setting and check the result when you add a new record.

Success Criteria

• Interface result: The configured default content appears in field settings.
• What you can do next: New records fill this field automatically with the default value.

Tips While Using

• Common mistake: After a default value is set, you may still need to adjust the content for specific records.
• Environment note: If the current table has special rules, confirm that field settings can be edited first.

3. Prevent Duplicate Values

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

1. Right-click the target text field title.
2. Select Field Settings.
3. Turn on Prevent Duplicate Entries in the settings panel.
4. Try entering duplicate content and check the prompt.

Success Criteria

• Interface result: The duplicate-prevention option is enabled in field settings.
• What you can do next: When duplicate content is entered, the system clears it and prompts you to revise it.

Tips While Using

• Common mistake: If duplicate data already exists, clean up existing content before relying on this rule.
• Environment note: Only one text field in a table can be set to prevent duplicate values.

4. Enter Text Content

Entry path: 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 Enter to confirm.

Success Criteria

• Interface result: The entered content appears in the target cell.
• What you can do next: You can continue editing, copying, or adding the next record.

Tips While Using

• Common mistake: If data that needs calculation is entered in a text field, it cannot be used directly in numeric calculations.
• Environment note: Long numeric identifiers are stored as text and are not included in automatic sums.