WPS Percentage Field on macOS FAQ

This FAQ focuses on 3 common questions about field type changes, filtering and grouping, and import checks for percentage data, plus a short glossary.

FAQ

Can I change a percentage field to another field type after creating it?

1. Right-click the target field and open Field Settings.
2. Find the entry related to changing the field type.
3. Select the new field type and confirm the change.
4. Before changing the type, check whether the existing data is compatible and back up the data if needed.

Can a percentage field be used for filtering and grouping?

1. Open the current Bitable data view.
2. Select the percentage field in the filtering or grouping settings.
3. Set the condition or grouping method based on your needs.
4. Review the result to confirm that the data is categorized as expected.

How can I make sure the percentage field type is correct after importing from Excel?

1. After importing the Excel data, check the current type of the target field first.
2. If the detected type is not what you expect, manually change the field to a percentage field.
3. Review the imported display format and data content for consistency.
4. If needed, adjust the data format in Excel before importing again.

Glossary