Skip to main content

Sorting filter

Create named sort options, bind them to a data control, and verify when and how the order changes.

Use Sorting Filter when readers need to reorder the same records. For example, a procurement page can let a user switch between newest orders and highest order amounts.


When to Use Sorting Filter

Use a sorting filter to offer named choices for the fields and directions readers use most. For a fixed order across several fields, such as amount followed by creation date, check the receiving table’s primary and secondary sort settings.


Add Sorting Filter Control

Drag Sorting Filter from the controls panel into a section or container on your form or dashboard.

You can use a Sorting Filter with Data Table, Gallery, Horizontal Timeline, Vertical Timeline, Collection, or Kanban Board.


Content Settings

Configure the filter variable and when it applies, then create the sorting options readers can select.

Basic settings

Under Content → Basic, set the title and check the Filter variable. Edit it or use Reset to choose an existing variable. Field titles

Under Apply type, choose Value change to apply the order as soon as the user switches options. Choose Click on apply button to apply it after the user clicks the linked button. Data filter apply types

In the target Data Table, open its data filter settings and select the associated variable in Sorting Filter. Check that the target uses fields from the same source as the configured sorting options. Sorting Filter in Data Table


Sorting List settings

  1. Choose the Application and Data source. Use a data list, document library, or data report.

  2. Under Sorting list, select +. Enter the Title readers will see, select the field under Order by, and choose ASC or DESC under Order. For example, use DESC on the amount field for Highest amount first.

  3. Add another choice such as Newest first. Use the clone or delete controls to manage the choices. To compare by more than one field, check the receiving Data Table’s Primary and Secondary order and verify which rule applies after a reader makes a selection.

Sorting list settings with the option title, Order by field, and an open ASC or DESC menu.


Appearance Settings

Set the placeholder, choose whether to display the title, and use dynamic display rules when the filter should appear only under certain conditions. Field titles · Dynamic display rules


Validation Settings

Use Readonly to prevent changes or Custom Validation to display a message for a configured condition. Custom Validation


Action Settings

Under Content → Action, select a configured action under Value Changed. In preview, check the action result and the displayed order when the selection changes.


Style Settings

  • Field - Editable. Set typography, placeholder color, alignment, padding, width, and field alignment. Configure text, background, border, radius, and shadow for normal and focus states. Style the error message separately.

  • Dropdown. Set typography, alignment, and padding. Configure text, background, border, radius, and shadow for normal, hover, and active states.

  • Field - Read Only. Set typography, text and background colors, alignment, padding, border, and radius.

  • Title. Use the title settings for the filter label. Field titles


Advanced Settings

Adjust the applicable layout settings. In preview, test records where the newest record and highest amount are different. Select both ways of sorting in turn and check which record appears first. If you use a secondary order, test two records tied on the primary field. With an apply button, also check the sequence before and after clicking it. Advanced options

Did this answer your question?