Help

Sort of Looked up Array Values

1774 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shomrei_Emunah
6 - Interface Innovator
6 - Interface Innovator

In a lookup field which returns multiple values (a comma separated array of values) the sort order seems random. Is there a way to sort this result alphabetically?

Thank you.

Screen_Shot_2018-11-20_at_2_24_39_PM

Screen Shot 2018-11-20 at 2.23.32 PM.png

1 Reply 1
jhoneybairstow1
4 - Data Explorer
4 - Data Explorer

Imagine you have a database or a data table that contains information about books, and you have two tables: one for books and another for authors. The "books" table has a field called "Title," and the "authors" table has a field called "Name."

To establish a relationship between the two tables, you create a lookup field in the "books" table that retrieves the names of authors for each book. Since a book can have multiple authors, the lookup field returns a comma-separated array of values (multiple author names) for each book.

For example, let's say you have the following data in the "books" table:

Book ID Title Authors (Lookup Field)
1 Book A John Doe, Jane Smith
2 Book B Michael Johnson, Anne Lee

In this case, the "Authors" field contains multiple values (author names) separated by commas.

Now, when you retrieve the data and display it, the lookup field's order may seem random:

Book ID Title Authors (Lookup Field)
1 Book A John Doe, Jane Smith
2 Book B Michael Johnson, Anne Lee