list() function does not allow sort
Operating system version
Description of the issue
When using the wonderful new list() function, the calculated field resort is not sorted.
Steps to reproduce the problem
Create a one to many relationship between two files: Contacts and Notes. Match on a field called contactID.
Contact file needs two fields:
Notes file needs three fields:
noteID contactID details
1 1 note3
2 1 note2
3 1 note1
4 1 note5
5 1 note4
Enter one record in Contacts for "John" with a contact ID of "1".
Enter 5 records in Notes
Create a new calculation field in Contacts called "Combine" and add the function:
Now look at the results of "Combine". The list is not sorted.
Ability to sort the list() function.
Can't find a way to sort the list() function
Exact text of any error message(s) that appear
No error, just frustration.
The ability to use a "sort" function on the "list()" function is what is needed. It might look like:
Excel or SQL