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
    • 13 days 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
    • 13 days ago
    • Reported - view

    Thanks Fred, it works!, Edwin (NL)

      • Fred
      • 13 days ago
      • Reported - view

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