I need help sorting the money column of my table please. I have clicked the gear icon on the column to set the sorting as descending. But it's not sorting from highest to lowest properly. Please see the screenshot attached and also the link here: https://prohoundmediamix.com/standings/state/new-york/
Edit: I have tried using the data tab to set the column type. But only "string" reads. All other options display 0.
Thank you for explaining. The dollar symbol is in the Excel spreadsheet. The spreadsheets are automatically generated. I will ask my client if a change can be made to generate them without the $ so that I can set the data type as float or integer.
Basically, if the source cells in this column from the Sheet have any symbols (such as $ or any other), this makes it a String Column in our Table, and that is why it can not have proper numerical sorting.
If you can change that on the source to have it generate numerical values as pure numerics without symbols, then you will be able to either go in our existing ( already linked) Table and just change this Column type from String to Float ( or integer), then just add a prefix as $ in the Column Display settings and the issue will be solved.
- Or, if you make a new Table then our Plugin will automatically 'guess' this Column should be Float ( or integer if it doesn't have decimals) and properly set it to the right numeric Data Type and not as String.
2. Just an additional possibly important detail. When you say the data in the Sheets/the spreadsheets are automatically generated, do you possibly include any kind of a formula/ or script on your source Sheet?
If so, we have a specific method when we try using a Google Sheet with Formulas, basically.
In all of our Testing, we are unable to get the Google Sheet with Formulas working properly, so we have this Guide which you can follow to have the Sheet with Formulas as data source without any issues.
In short, the main idea is to make a new Sheet Tab/ or a completely new Sheet, which is blank, then add the !importrange in the A1 cell, so this passes all the values from the Original Sheet after the Formulas are finished, then our Table gets just the pure 'finished values', if that makes sense.
So you can still work/edit anything you need on the Original Sheet that has Formulas and certain Formatting,
while our Table will just pick up the final values after the formulas go through them on the second connected Sheet Tab.
What we said about the numerics with symbols still applies, this is just an additional side note to check, just to avoid any possible issues if you use Google Sheet formulas.
Sorting is working now. I asked my client to remove all $ from their Excel spreadsheets. I added $ to the cell content prefix field and changed the data type to float. Thanks for your help!
I need help sorting the money column of my table please. I have clicked the gear icon on the column to set the sorting as descending. But it's not sorting from highest to lowest properly. Please see the screenshot attached and also the link here: https://prohoundmediamix.com/standings/state/new-york/
Edit: I have tried using the data tab to set the column type. But only "string" reads. All other options display 0.
Attached files: Screenshot 2024-07-23 at 9.43.47 AM.png
Hi Kristy,
Can you please check what is the Column data type for the "Earnings"?
It seems it might be set as a String column?
Can you tell me do you have this currency symbol inside the cells where your numeric data is on the source Sheet?
If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.
The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Google Sheet,
then you can make integer or Float Column from this in our connected Table.
( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)
After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.
Then you will be able to change this Column from String to numeric, such as Float or integer, and you can have numerical sorting.
If you use the Column as String, then you can't have numerical sorting - any Strings in the Plugin an only sort as alphabetical order.
Let me know if that helps.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi Miloš,
Thank you for explaining. The dollar symbol is in the Excel spreadsheet. The spreadsheets are automatically generated. I will ask my client if a change can be made to generate them without the $ so that I can set the data type as float or integer.
Hi Kristy,
You're welcome.
Basically, if the source cells in this column from the Sheet have any symbols (such as $ or any other), this makes it a String Column in our Table, and that is why it can not have proper numerical sorting.
If you can change that on the source to have it generate numerical values as pure numerics without symbols, then you will be able to either go in our existing ( already linked) Table and just change this Column type from String to Float ( or integer), then just add a prefix as $ in the Column Display settings and the issue will be solved.
- Or, if you make a new Table then our Plugin will automatically 'guess' this Column should be Float ( or integer if it doesn't have decimals) and properly set it to the right numeric Data Type and not as String.
2. Just an additional possibly important detail. When you say the data in the Sheets/the spreadsheets are automatically generated, do you possibly include any kind of a formula/ or script on your source Sheet?
If so, we have a specific method when we try using a Google Sheet with Formulas, basically.
In all of our Testing, we are unable to get the Google Sheet with Formulas working properly, so we have this Guide which you can follow to have the Sheet with Formulas as data source without any issues.
In short, the main idea is to make a new Sheet Tab/ or a completely new Sheet, which is blank, then add the !importrange in the A1 cell, so this passes all the values from the Original Sheet after the Formulas are finished, then our Table gets just the pure 'finished values', if that makes sense.
So you can still work/edit anything you need on the Original Sheet that has Formulas and certain Formatting,
while our Table will just pick up the final values after the formulas go through them on the second connected Sheet Tab.
What we said about the numerics with symbols still applies, this is just an additional side note to check, just to avoid any possible issues if you use Google Sheet formulas.
Let me know how it goes.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Sorting is working now. I asked my client to remove all $ from their Excel spreadsheets. I added $ to the cell content prefix field and changed the data type to float. Thanks for your help!
Hi Kristy,
I am glad to see this has been solved.
We will go over your remaining open ticket as soon as possible.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables