How to Use WPS Data Table Checkboxes on Android

Use WPS Data Table Checkboxes through 4 operation topics on Android; 4 are free and 0 are membership-related.

How-to Index

How-to Guide

1. Create a checkbox field

Entry: Tap the table header → Edit → Field Type → Checkbox

1. Open the target multidimensional table in WPS Office on Android.
2. Tap the header that you want to configure.
3. In the floating toolbar, tap Edit.
4. In the field editing window, tap Field Type.
5. Select Checkbox.
6. Enter the field name and confirm to finish creation.

Success Criteria

• Interface result: The header shows the new field name, and the field type is Checkbox.
• What you can do next: Record rows show a tappable checkbox control.

Tips While Using

• Common mistake: If you do not enter the field editing window, you cannot change the field type.
• Environment limit: You need permission to edit fields in the current table.

2. Toggle checkbox status

Entry: Tap the checkbox field cell

1. Open a table that already contains a checkbox field.
2. Find the checkbox field cell in the target record.
3. Tap the checkbox to switch it to the checked state.
4. Tap it again to switch it back to the unchecked state.

Success Criteria

• Interface result: A checked box shows the selected state, and an unchecked box shows an empty box.
• What you can do next: You can continue editing other records or apply filters.

Tips While Using

• Common mistake: Tapping the header editing area does not change the record state.
• Environment limit: If the table is read-only, you cannot change the checkbox result.

3. Filter records by checkbox status

Entry: Table filter settings → Select the checkbox field

1. Open a table that contains a checkbox field.
2. Open the filter settings.
3. Select the target checkbox field as the filter condition.
4. Choose Checked or Unchecked as the filter value.
5. Apply the filter and review the result records.

Success Criteria

• Interface result: The list shows only records that match the checkbox condition.
• What you can do next: You can continue viewing or editing records in the filtered result.

Tips While Using

• Common mistake: If you choose the wrong field for the filter, the result will not change by checkbox status.
• Environment limit: The table must support filtering and provide access to the filter entry.

4. Reference checkbox values in formulas

Entry: Formula field or formula editing area

1. Open the formula field that you want to calculate in the table, or create a new formula field.
2. Insert the target checkbox field into the formula.
3. Build the calculation with the checkbox values, where checked equals 1 and unchecked equals 0.
4. Save the formula and review the result.

Success Criteria

• Interface result: The formula result changes when the checkbox state changes.
• What you can do next: You can continue combining other fields in the calculation.

Tips While Using

• Common mistake: Treating the checkbox as text can cause unexpected formula results.
• Environment limit: The current table must support formula field editing.