WPS Multidimensional Text Field on Windows FAQ

Common questions about WPS Multidimensional Text Field usually focus on field selection, field conversion, duplicate handling, and default-value limits; this FAQ includes 4 common questions.

FAQ

What is the difference between a text field and a number field?

1. A text field stores content as strings and is suitable for text, symbols, and long numeric identifiers.
2. A number field is designed for numeric data and is suitable for calculations, statistics, and formatted numeric display.
3. If the content is an ID number, document number, or bank card number that should not be calculated, use a text field.

How do I convert an existing number field to a text field?

1. Right-click the target field title.
2. Select Field Settings.
3. Change the field type from Number to Text.
4. Check existing data before switching so that format changes do not affect later use.

What should I do with existing duplicates after duplicate prevention is enabled?

1. Before turning on Prevent Duplicate Entries, check whether the current field already contains duplicate content.
2. Manually edit or delete duplicate items.
3. Re-enter the content you want to keep and confirm that later records do not repeat it.

Why can default values and duplicate prevention be difficult to use together in a normal workflow?

1. When a text field has a default value, new records are filled with the same content automatically.
2. If duplicate prevention is also required, the same default content is treated as a duplicate entry.
3. If you need consistent prefilled content, review whether duplicate prevention is necessary for that field.

Glossary