How to Use WPS Data Table Sorting on Android

Use Data Table Sorting through 4 how-to topics, all available without membership; you can add sorting, apply multiple sort conditions, keep persistent sorting rules, and manually move records.

How-to Index

How-to Guide

1. Add a sort condition

Entry path: Bottom toolbar → Filter → Sort → Add sort condition

1. Open the data table you want to organize.
2. Tap Filter on the bottom toolbar.
3. In the pop-up panel, select Sort.
4. Tap Add sort condition.
5. Select the field you want to sort by.
6. Choose Ascending or Descending.
7. Tap OK.
8. Tap Apply to finish.

Success Criteria

• The records in the current data table are reordered by the selected field.
• The sort panel shows the condition you added.
• The data itself remains unchanged.

Tips While Using

• Sorting changes only the display order and does not change the original data.
• Before choosing a field, confirm that its values are suitable for comparison and sorting.

2. Set multiple sort conditions

Entry path: Bottom toolbar → Filter → Sort → Add sort condition

1. Open the Sort panel by using the path above.
2. Tap Add sort condition and set the first field and order.
3. Tap Add sort condition again.
4. Select the second field and its order.
5. Continue adding more conditions if needed.
6. Tap OK.
7. Tap Apply to make all conditions take effect together.

Success Criteria

• The sort panel shows two or more sort conditions.
• Records are reordered by condition priority.
• Records with the same primary sort value continue to be organized by later conditions.

Tips While Using

• Multiple sort conditions take effect in the order they are added.
• If you use many conditions, set the main field first and then add secondary fields.

3. Turn on Always sort by the following rules

Entry path: Bottom toolbar → Filter → Sort

1. Open the data table and enter the Sort panel.
2. Add at least one sort condition first.
3. Turn on Always sort by the following rules.
4. Tap Apply to save the setting.
5. After new or updated records appear, check whether they return to the expected position automatically.

Success Criteria

• The current records stay in the selected order after the rule is saved.
• New records move into the expected position after they are saved.
• You do not need to repeat the same sorting action each time.

Tips While Using

• If record order needs to stay consistent over time, this option is useful.
• If you want to review the original arrival order temporarily, first check whether persistent sorting is turned on.

4. Manually drag a record to a new position

Entry path: Select a record and long-press to drag

1. Select the record you want to move.
2. Long-press the record.
3. Drag it to the target position.
4. Release your finger to finish.

Success Criteria

• The record moves to the new display position.
• Other records adjust around the moved record.
• The table can still be filtered or sorted afterward.

Tips While Using

• Manual dragging works well for temporary adjustments to a small number of records.
• If persistent sorting is already turned on, later updates may still reorder records by the saved rules.