Alphabetizing responses to a repeat question

Question

Hi all,

I have a survey where users identify all the plant species in an area. Users select a species in the repeat and some additional information, then repeat for each species they see. There is a need for the surveyor to see the list of species they have observed, which can get quite long. I have created a HTML table that lists all the species observed and their associated data as a note in the repeat below.

This works well, but can make going back and finding if you entered a species already difficult if you have 100+ entries. Is there a way to alphabetize such a list by species? Open to different list building methodologies as well.

S_-_EvanRaskin__GISS_ · Answer

Ah, I see, thanks. I noticed that the first few species codes in your example screenshot were alphabetical, but I see now that they aren't all alphabetical, and the first few were only because of the order in which they were entered.

The JavaScript function suggested below didn't work for me, but I eventually came up with one that does (with help from Microsoft Copilot). Happy to share if anyone wants it, but it's tailored specifically to work with the way I have built my table, so I won't post it here.

Here is example output. The # field is the repeat index (order in which species were entered) to make it easier to find a species in the repeat if you need to make a change.

dougbrowning · Answer

I do not know of any way to order them, join is the order they were created is all you can do.  Would have to be a javascript addin prob.

S_-_EvanRaskin__GISS_ · Answer

@DougBrowning, can you explain how this works? I see that you posted an explanation here, but I'm not trying to summarize from the repeat, just want to review records from the repeat as a table(/grid), and it would be great to have them alphabetized rather than just in an HTML table. I'm doing something similar to the OP (building a species list and would like to review it as an alphabetized table). I see that you mentioned using join() for display rather than summarizing, but I haven't gotten it to work and would love a little additional guidance. Thanks!