Sorting of Table data in NXT so it appears in drop down menus in alphabetical order same as it does in the FE Database version.

The database view of Tables, specifically "Transaction Codes 1", has a sort function. This allows the data in the table and connected drop down menus in other applications such as GL coding in AP to appear in alphabetical order. As an organization we have over 40 active grants and 178 total grants. We use this table to name our grants. When a person does not remember the entry spelling by heart, having the information in alphabetical order is very convenient. Would you like to scroll through 100 drop down menu options not in alphabetical order? Although the database view has this function, the NXT version does not. Before you remove the database view functionality because in NXT is fully functional, please add this function to NXT. NXT might be functional, but it does not offer the same functionality. Or do something behind the scenes so the table sorts automatically.

  • Guest
  • Aug 24 2023
  • No Status
  • Attach files
  • Kristy Soular commented
    21 Jun 05:59pm

    Any updates from Blackbaud on this? They took away the ability to do this in database