How to Use WPS Number on Android

Use WPS Number with 4 how-to topics, including creating fields, entering values, using formulas, and choosing the right field type; 4 items are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Create a number field

Entry point: Tap the header → Edit → Field Type → Number

1. Tap the header that you want to configure.
2. In the floating toolbar, tap Edit.
3. In the field editing window, tap Field Type.
4. Select Number.
5. Set the field name, then confirm to finish creation.

Success Criteria

• On-screen result: A new number field column appears in the table.
• What you can do next: You can enter numeric values in records under this field.

Tips While Using

• Common mistake: If you do not enter header editing first, you cannot change the field type.
• Environment note: You need edit permission for the current smart table.

2. Enter numeric values

Entry point: Tap the target cell → Record Details → Number field

1. Tap the target cell to open record details.
2. In record details, tap the related number field.
3. Enter the numeric value that you want to save.
4. Return to the record details page and confirm that the value has been saved.

Success Criteria

• On-screen result: The number field shows the value that you entered.
• What you can do next: You can continue editing other fields or return to the table.

Tips While Using

• Common mistake: Enter numeric content only and avoid unrelated characters.

3. Use a number field in formulas

Entry point: In a formula-related field setting, choose the number field as a reference

1. Confirm that the smart table already contains a usable number field.
2. Open the place where you set up the formula.
3. Select the number field as a reference in the formula.
4. Save the formula and check whether the result is displayed correctly.

Success Criteria

• On-screen result: The formula result updates when the number field changes.
• What you can do next: You can continue adjusting the formula or editing the original value.

Tips While Using

• Common mistake: If a non-numeric field is referenced, the calculation may not return the expected result.

4. Choose between number and currency fields

Entry point: Open the field type list when creating a field

1. Open the header editing window.
2. Enter the Field Type list.
3. Review both Number and Currency field types.
4. Choose Number for general values and Currency for money-related values.
5. Confirm the selection and finish creating the field.

Success Criteria

• On-screen result: The selected field type matches the business scenario.
• What you can do next: You can continue entering values according to the selected field type.

Tips While Using

• Common mistake: If you use a number field for money values, a currency symbol is not added automatically.