Can't seem to get the 'total wages' and 'average wage' column from Google sheet to table preview. No formulas involved, only integers. Just shows zeros for that data in table preview.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Can you tell me do you have any symbols inside the cells where your numeric data is,
for example a currency sign?
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.
Can't seem to get the 'total wages' and 'average wage' column from Google sheet to table preview. No formulas involved, only integers. Just shows zeros for that data in table preview.
Hi Matt,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
Can you tell me do you have any symbols inside the cells where your numeric data is,
for example a currency sign?
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.
Let me know if that helps.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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