Set Relationship Sort

The Set Relationship Sort action sorts the rows of a relationship table (relationship editor) based on the values in a selected field. This is useful for organizing related data in ascending or descending order, such as sorting by date, number, or text.

Properties and Explanation

Select Relationship: Choose the relationship editor (table) whose rows you want to sort. This is the target table for the sorting operation.

Fields in Table: Select the field(s) in the relationship table to use as the sort key. The values in this field will determine the order of the rows.

Descending: If checked, the rows will be sorted in descending order (highest to lowest, Z-A, or latest date first). If unchecked, the rows will be sorted in ascending order.

• The action supports sorting by number, date, or alphanumeric values, and automatically detects the field type.

• You can use this action to keep related data organized and easy to review for users.

Full Configuration Example

Below is a screenshot of the Set Relationship Sort action configuration, showing all properties set for relationship selection, field selection, and sort order:

• In this example, the relationship table is sorted by a selected field in either ascending or descending order, as configured.

• When the action is triggered, the table updates to reflect the new sort order.