WordPress.org

Ready to get started?Download WordPress

Forums

TablePress
[resolved] Sorting Currencies in Table (6 posts)

  1. burlyqlady
    Member
    Posted 6 months ago #

    Hi! I've searched through the site and couldn't find a specific answer to my problem or the fixes referenced aren't working for me.

    My table is set up here. I'm trying to sort tables 2, 3 and 4 (the shipping tables) by currency and it's not working out. I ran into another thread with this problem so I installed the Datatables Sorting extension and added this command: "aoColumnDefs": [ { "sType": "formatted-num", "aTargets": [ 2, 3, 4 ] } ]

    which I'm not sure was the right thing to do.. anyway, that didn't work. I'm using the current version of the plugin as well as the current version of wordpress. I'm getting this in Firebug, I don't know if it helps: http://i.imgur.com/kNWbfLO.png

    Also, I was wondering if there's a way to use this chart with a currency converter API (such as this one) so I could implicitly convert everything and then sort by the values people can't see? I hope I just made sense!

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

  2. TobiasBg
    Member
    Plugin Author

    Posted 6 months ago #

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, that Extension will not really be helpful in your table, as not all cells in these three columns contain currencies. You also have cells that have string (like "Free"), or are empty (like "-"), or contain multiple currency values. In sum, this means that those columns can not be sorted, because the script does not and can not know what to do with all of these different things. It can only handle columns where all cells contain a currency value.

    That Firebug issue is independent of this and does not influence the behavior.

    Using the Currency Converter API could be possible with some "Custom Commands" for the DataTables JS library, which allow the script to sort on data that has been hidden from the user.
    First of all you should integrate that API though.

    Regards,
    Tobias

  3. burlyqlady
    Member
    Posted 6 months ago #

    okay, so how can I sort all of these manually? I just looked at the API documentation and I'm a newb in integrating APIs (thought I could do it but it'll take longer for me as I have no programming knowledge, etc.)

  4. TobiasBg
    Member
    Plugin Author

    Posted 6 months ago #

    Hi,

    what do you mean with sort manually now? Do you mean drag and drop to the desired order?
    If you want to use the Currency Converter API, you'll need to find a plugin that integrates that into WordPress.

    Regards,
    Tobias

  5. burlyqlady
    Member
    Posted 6 months ago #

    Hi again,

    Yes, I'm giving up on using the API as it's a little out of my depth (
    I'm not a programmer) and will take too long for me to figure out and set up. It's really not my thing.

    So if I take out all the ranges in the columns (so there's just one price listed) - like a min and max column - would it sort better? or can I just do it manually? Like drag and drop, yes, and everything would be fixed so the user can't sort.

  6. TobiasBg
    Member
    Plugin Author

    Posted 6 months ago #

    Hi,

    thanks for the clarification! Yes, the best option would then be to set the order manually (you can drag and drop the rows on the "Edit" screen, by clicking and holding the row number on the very left of each row).
    To then prevent the user from sorting the columns, please add this to the "Custom Commands" textfield on the "Edit" screen of the table:

    "aoColumnDefs": [ { "bSortable": false, "aTargets": [ 2, 3, 4 ] } ]

    Regards,
    Tobias

Reply

You must log in to post.

About this Plugin

About this Topic