When using WPS Sort on iOS, users often ask about 3 common topics: where new records appear, whether multi-column sorting is supported, and how sorting works with filters.
FAQ
Where do newly added records appear after sorting?
- After you add a new record, it appears at the end of the current list by default.
- If Always sort by the following rules is already enabled, the table reorders the record after saving.
- When you return to the data table, the new record appears in the position that matches the saved rules.
Can I sort by multiple columns at the same time?
- Open Filter on the bottom toolbar and go to Sort.
- Tap Add Sort Condition and set the first field.
- Continue adding other fields to sort by multiple conditions in priority order.
Can sorting and filtering be used together?
- Yes. You can set a filter first to narrow the visible range.
- Then open Sort and apply a sorting rule to the current result.
- Sorting and filtering can work together, and sorting changes display order only.
Glossary
| Term | Definition |
|---|---|
| Sort condition | A combination of a field and a sorting rule that determines how records are ordered, such as sorting by date in ascending order or quantity in descending order. |
| Ascending / Descending | Ascending usually means from smaller to larger or earlier to later, while descending usually means from larger to smaller or later to earlier. |
| Always sort by the following rules | When this option is turned on, the data table keeps using the saved sort conditions, and newly added records return to the matching position after saving. |