0

Issues with sorting in an overview of linked fields from another table

If a reference is made within a table to another table via “Choice (dynamic)”, the correct data is displayed in the form. However, in the view, sorting is based on the ID of the subtable, and in the report, the names are displayed as numbers, i.e., the ID from the underlying table. Can this be resolved?

3 replies

null
    • Fred
    • 1 mth ago
    • Reported - view

    if you put text() around the dynamic choice in the formula for the column then it will sort properly.

    Before:

    After:

    • Edwin_Thier
    • 1 mth ago
    • Reported - view

    Thanks Fred, it works!, Edwin (NL)

      • Fred
      • 1 mth ago
      • Reported - view

      When you get a chance please mark the post "answered". 🙂