WPS Text Field on macOS FAQ

Common Text Field questions usually focus on field type selection, default values, duplicate prevention, and how to store identifiers; this section covers 4 frequent 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 more suitable for calculations, statistics, and numeric formatting.
3. If the content is an ID number, document number, bank card number, or another long identifier, use a text field first to avoid formatting or precision issues.

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

1. Right-click the target field title.
2. Open Field Settings.
3. Change the field type to Text.
4. Before switching, check the existing data to make sure the converted result matches your expectations.

What should I do with existing duplicate data after turning on duplicate prevention?

1. Check whether duplicate content already exists in the current field.
2. Edit or delete the duplicate items manually.
3. Then continue using the duplicate-prevention rule for new entries.
4. If the system reports duplicates, finish the cleanup before continuing.

Why can’t default values and duplicate prevention be used together?

1. A default value fills the same content automatically when a new record is added.
2. Duplicate prevention requires field content to stay different.
3. Because these two rules can conflict, choose the one that matches your actual business scenario.

Glossary