Setting the sort type for columns in the Edit Grid component

When working with the Edit Grid component, the modeler can choose the sort type to apply to the component’s columns.

You can sort values as numeric (Sort as number) or as text for components that are part of the Edit Grid.

  1. Sign in to the regulations administrator portal.

  2. Open the UI forms section.

    ui forms 1

  3. Create a form or select one from the list.

  4. Open the Builder tab.

  5. In the components panel on the left, select Updated.

  6. Find the Edit Grid component and drag it onto the modeling canvas.

    edit grid sort as number 1

  7. In the new window, click Save.

    edit grid sort as number 2

  8. Add components to the Edit Grid according to the business logic—​for example, Text Field та Number.

    edit grid sort as number 3

    edit grid sort as number 4

    As a result, the modeling canvas looks like this:

    edit grid sort as number 5

  9. Open the settings for each component (Text Field and Number) and select the Sort As Number checkbox in the Display tab.

    The Sort As Number function determines whether the component’s value should be treated as numeric when sorting in grids.

    edit grid sort as number 6 edit grid sort as number 7

  10. Click Save.

  11. Open the Preview tab to see how sorting works.

  12. Click Add to fill out the table.

    edit grid sort as number 8

  13. In the new window, fill out the fields and click Save.

  14. Add more records to the table if necessary.

    edit grid sort as number 9

As a result, if you sort the Text Field component in descending order, numeric values are displayed at the top, and text values at the bottom.

edit grid sort as number 10

If you sort the Number component, the numeric values are sorted in ascending or descending order.

edit grid sort as number 11