Need a Column to Sort in Alphabetical or Numeric Order Automatically

Hi,

thanks for your question, and sorry for the trouble.

Yes, this is possible. The quickest way would probably be to simply sort the table manually after adding rows to it or after editing it. For that, just use the sorting icons that appear on the “Edit” screen when you hover over the column header letters with the mouse.

If that’s not what you’d like, just let me know and I can find a JS command that will tell the browser to sort the table automatically when it’s loaded by a visitor.

Regards,
Tobias

Hello! I am in need of the javascript that will automatically alphabetize. Can you help? I have a site that has massive lists of sponsors, so going in and alphabetizing by hand will not be very efficient. Thank you so much!!!

Hi,

thanks for your question, and sorry for the trouble.

Why is the sorting functionality on the “Edit” screen not working for you? Just click the sorting arrow icon that appears next to the letter for the column header when you hover with the mouse of it (e.g. the “A” if you want to sort the first column).

Regards,
Tobias

It is not working for me to use the sorting functionality on the edit screen, as everything in the list has a link attached to it, so everything starts with <a href…. Thus, it is not alphabetizing as it should, due to the beginning portion of each of the listings being the same.

I have tried repeatedly to sort within the edit screen, but it simply isn’t working on my end. By the time the show begins, we will have upwards of fifty items in this table, and it’s simply not efficient to have to sort it by hand each time.

This is the page I’m trying to sort (each of these tables need to be alphabetized as we add listings)

https://wineandfoodexpoiowa.com/show-features/exhibitors/

I have done the beer one by hand, but am hoping for a workaround so that it will do this automatically. It’s very hard to sort with the hyperlink code in the front, because you cannot easily see what the item in the table is without clicking on the code.

Hi,

thanks for the link! Now I understand. The problem is indeed coming from the links, as the sorting on the “Edit” screen can not account for those.
We can however tell the DataTables JS library to perform an initial sort on the first column, when the table is loaded. For that, please add this to the “Custom Commands” text field on the “Edit” screen of affected tables:

"order": [[ 0, 'asc' ]]

Regards,
Tobias

Hello! I am having trouble with table press pushing some of the data in my rows to the right? I have css telling it to align left, and it’s working fine on all but one table. Can you please advise?

https://wineandfoodexpoiowa.com/show-features/exhibitors/#food

It appears to be the top listing that is pushing to the right… and it is no longer alphabetizing

Hi,

thanks for your question, and sorry for the trouble.

The reason for this is a wrong quotation mark in one of the cells (in row 6).
There, the code

<a href="https://www.scratchcupcakery.com”>Scratch Cupcakery</a>

has to be changed to

<a href="https://www.scratchcupcakery.com">Scratch Cupcakery</a>

Note the slightly different quotation mark after the URL.

Regards,
Tobias