Sorting Records

To sort records by a single field, tap a column header in Table View.

Sort records by multiple fields

  1. Do one of the following:
    • iPhone: Tap Manage records icon, then tap Sort Records Sort records icon.
    • iPad: Tap Sort records icon.
  2. In the Edit Sort Order screen, tap Select Fields Select fields icon, then select the fields that you want to sort by, in the order that you want them sorted.
  3. Tap Left arrow icon to go back.
  4. To place a new or changed record that's in sorted order into the adjusted order after you commit the record, turn on "Keep records in sorted order." When this option is turned off, new or changed records stay in the same position in the sort order until you perform a find or until you sort the records by different criteria.
  5. To change the order of a field in the sort list, tap Sort order icon and drag the field up or down.
  6. To remove a field from the sort list, tap the field in the sort order, tap Remove field from sort order icon, then tap Remove.
  7. To customize the sort order, tap the field in the sort list. Tap Ascending, Descending, or By Value List, then tap Left arrow icon.
  8. If there is a summary field in the file and you want to reorder by summary totals, tap any field in the sort list. Turn on "Reorder by summary totals." Choose the summary field, then tap Left arrow icon.
  9. Tap Sort.

Return records to their creation order

  1. Do one of the following:
    • iPhone: Tap Manage records icon, then tap Sort Records Sort records icon.
    • iPad: Tap Sort records icon.
  2. Tap Unsort.

Notes