Sorting List Collector variable values

[Erica2]

Hello,

We have a software list collector that contains 'Other'.  The list currently sort by alphabetical order.  Is it possible to move the 'Other' value to the bottom of the list?  Thank you

[Anurag Tripathi]

Sorry yours is a list collector, this is for drop downs.

I'll keep thinking and post back if I find something similar for list collector

[Erica2]

Thank you so much @Anurag Tripathi  for your time and effort.

[Riya Verma]

Hi @Erica2 ,

Hope you are doing great.

Try using below script n pn load client script:

function onLoad() {
    // Check if the form is in the correct view and table
    if (g_form.getTableName() == 'your_table_name') {
        var listCollector = g_form.getControl('your_list_collector_field');
        
        if (listCollector) {
            // Get the options from the list collector
            var options = listCollector.options;
            
            // Custom sort function to move 'Other' to the bottom
            Array.prototype.sort.call(options, function(a, b) {
                if (a.text == 'Other') return 1;
                if (b.text == 'Other') return -1;
                return a.text.localeCompare(b.text);
            });
            
            // Refresh the list collector to apply the new sort order
            g_form.refresh();
        }
    }
}

[Erica2]

Hi @Riya Verma 

I'm still facing the same issue after tried your suggestion:  Thank you