• Resolved Fabbstar

    (@fabbstar)


    Hey There,

    Really great plugin, just what we needed.

    A quick question, we have a price column which we’ve set as ‘numbers’ in the column options. By doing this we can sort in price order.

    How do I make it so a £ or $ sign can be placed in the column prior to the number in a way that doesn’t affect the sorting?

    Many thanks!
    F

Viewing 1 replies (of 1 total)
  • Plugin Author MyThirdEye

    (@mythirdeye)

    Hello @fabbstar

    I just tried it out and indeed sorting does not work properly if you add $ in front of the number.

    I will include this as a feature request and somehow make it so you can add money signs before a cell value.

    In the meantime, if you require this feature right away, you can do some custom CSS to include $ the cells, here is how you would go about doing that:

    #jtrt_table_82 tbody tr td:nth-child(3):before{
        content:"$";
    }

    1. Change #jtrt_table_82, the 82 is the table ID, change it so it matches the table you want to target.

    2. Change td:nth-child(3), the 3, you need to change 3 to the right column number for your price. For example, if the table looks like this:
    ![](http://i.imgur.com/OIU2TOT.jpg)

    the price column is the 3rd one, so I would have nth-child(3) as my selector. If your price column is the 6th from the start, use 6.

    3. Change content:”$”;, change the $ to the correct money sign you want to display.

    This custom css will add $ before your price column, hopefully this helps you out.

    I will add this as a feature in the future so others wont have to fumble around with custom css code.

    Thanks for using my plugin and for bringing this issue to my attention.

    John

Viewing 1 replies (of 1 total)

The topic ‘Sorting with £ or $ Signs’ is closed to new replies.