I have a project in development mode as we convert from Joomla to Wordpress. I though this would be a great option for our league standings (we have 17 age groups amongst our sports leagues). We sort standings by calculated win percentage. Turns out, I can't sort by a calculated formula. Oddly, this is the single most important thing for the standings.
Am I missing something that will allow it? Sorting by Wins is not good enough.
Unfortunately that is not possible with built in features of plugin. But you can make it with some workaround. You can add one more column and set Column type to float. Then copy all the data from formula column to new one so they look the same. Then you can set for that new column option Use as default sorting column on SORTING tab in column settings and choose Default sorting direction what you need. Then turn off option Visible on front-end on DATA tab also in column settings so ti will not be visible. Like this your table will be sorted like you requested.
I have a project in development mode as we convert from Joomla to Wordpress. I though this would be a great option for our league standings (we have 17 age groups amongst our sports leagues). We sort standings by calculated win percentage. Turns out, I can't sort by a calculated formula. Oddly, this is the single most important thing for the standings.
Am I missing something that will allow it? Sorting by Wins is not good enough.
Hi FirstPageMedia,
Thank you for your purchase.
Unfortunately that is not possible with built in features of plugin. But you can make it with some workaround. You can add one more column and set Column type to float. Then copy all the data from formula column to new one so they look the same. Then you can set for that new column option Use as default sorting column on SORTING tab in column settings and choose Default sorting direction what you need. Then turn off option Visible on front-end on DATA tab also in column settings so ti will not be visible. Like this your table will be sorted like you requested.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables