Use WPS Checkbox Field on Windows with 3 how-to topics, all available without membership, to create a field, switch checkbox states, and set a default checked value.
How-to Index
| No. | Topic | Membership Requirement |
|---|---|---|
| 1 | 1. Create a checkbox field | Free |
| 2 | 2. Toggle checkbox status | Free |
| 3 | 3. Set a default checked state | Free |
How-to Guide
1. Create a checkbox field
Entry: Click the + button on the right side of the header → field type list → Checkbox
- Click the + button on the right side of the table header.
- In the field type list, select Checkbox.
- Enter a field name.
- Click OK to finish creating the field.
Success Criteria
- Interface result: A new checkbox field column appears in the table.
- What you can do next: You can click cells in that column to change their status.
Tips While Using
- Use a field name that matches the business meaning, such as Completed or Confirmed.
- You need permission to edit fields in the current WPS Tables sheet.
2. Toggle checkbox status
Entry: Target cell → click directly to check or uncheck
- Find the target cell in the checkbox field column.
- Click the cell to switch it to checked or unchecked.
- A checked state shows a check mark, while an unchecked state shows an empty box.
- Repeat the action for more records when you need batch status updates.
Success Criteria
- Interface result: The cell switches between checked and unchecked states.
- What you can do next: You can continue filtering, grouping, or reviewing records by status.
Tips While Using
- A checkbox field is suitable for binary states, not for storing multiple labels.
- Before batch updates, confirm the current filter range to avoid changing the wrong records.
3. Set a default checked state
Entry: Right-click the field title → Field Settings → Default checked
- Right-click the checkbox field title.
- Select Field Settings.
- Turn on Default checked.
- Save the setting so new records are checked by default.
Success Criteria
- Interface result: The default checked option is enabled in field settings.
- What you can do next: Newly added records automatically appear as checked in this field.
Tips While Using
- Default checked is useful when new records should start from the same initial state.
- If the workflow changes later, open field settings again and adjust the default state.