• Resolved Leandros1962

    (@leandros1962)


    Hi Tobias — This plugin is great!
    My question: I would like to add new rows at the top of the table or between the existing rows of the table or at least to sort the table in alfabetical order using two columns at the same time.
    For example, my table contains data in two columns: year, name
    and I’d like to have the table sorted first by “year” and then by “name”.
    I thing that in the previeus version of your plugin there was the possibility, but now not.
    Can you help me?

    http://wordpress.org/extend/plugins/tablepress/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question.

    You can insert new rows by clicking the checkbox on the left of the existing row and then use the “Selected Rows: Insert” button.

    Sorting on two columns on the “Edit” screen is not possible, unfortunately (and wasn’t possible in WP-Table Reloaded either). You can however sort on two columns when viewing the table in a page. Just hold the “Shift” key while clicking on the table head cell of the second column.

    Now, for more advanced sorting activity (like in your case), it is usually a good idea to export the table to a CSV file, open that in Excel, do the sort operations there, sav to CSV again and then re-import that file into TablePress.

    Regards,
    Tobias

    Thread Starter Leandros1962

    (@leandros1962)

    Thanks for the immediate response. Inserting new rows is enough for now.
    Wishes for the New Year.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! 🙂 Great to hear that this will help!

    Best wishes and a Happy New Year, too!
    Tobias

    Is it possible to add a second column to the sort in the short code? What is the proper format? In my case I am sorting on column E (Graduation Year) but would then like to sort on column B (Name) within that year.
    Thank you for your assistance.
    [table id=6 / row_order=”sort” row_order_sort_column=”E” row_order_sort_direction=”ASCE” /]

    I saw in another post that sorting on 2 columns in not supported. Sorry for the question.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your question, and sorry for the trouble.

    Yes, as you have already seen, sorting on two columns is not supported in the Shortcode at this time. Sorry 🙁 I might be able to implement this in the future, but I can’t give an estimate on when this might be available.

    As a sidenote: You have an extra / in your Shortcode (before teh row_order parameter and you should remove that. Also, the “ASCE” should be “ASC” only. Thus, your Shortcode should be

    [table id=6 row_order="sort" row_order_sort_column="E" row_order_sort_direction="ASC" /]

    Best wishes,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘sort columns’ is closed to new replies.