Much like your Address Books, you can sort all of the information in your Table Documents using the column headers in the table. When a Table Document is being viewed or edited, a click in any column header will sort the column in ascending order. A second click in the column header will sort in descending order.
Which columns can be sorted? By default, all columns are sortable but when your are editing a Table Document you can turn this sorting feature off on any column that you wish.
Sorting in view mode vs. edit mode
- View - any sorting changes that you make in “view” mode are only temporary. As soon as you exit your Table Document the sorting will return to what it was before your viewed your document. The same will be true of any Visitors that view your Table Document. The Table Document will not be permanently changed. However, if you print or export your Table Document from the “view” screen then the sorting changes will be reflected in the final product. For example, if you want to have a printout of the Table Document sorted by “Last Name”, you can just click on that header to do the sort and then print.
- Edit - any sorting changes that you make on the Table Document will be permanent after you save the Document. All Visitors from that point on will view or edit the Table Document in the newly sorted order.
How the sorting order is determined
Columns are sorted depending on their type:
- Text and Choice - Case sensitive (upper case comes before lower case) string sort on the displayed value.
- Number and Unique Number - numeric sort on internal value - displayed value is ignored.
- Date - sort on date value (not on the text representation of that value).
- Check box - unchecked sorts as lower than checked.
Learn more about sorting Table Documents using multiple columns.