Comments lucas started the conversationJuly 8, 2024 at 3:31amI have mainly two questions1. I've tried syncing this google sheet onto wpdatatable, it has percentage & dollar value in it. Click here for google sheet.However, when its on wpdatatable, it will not show the exact decimal point of the %/ dollar value like what i've placed in google sheet.It will only show the exact %/value when im using 'string' as the column type, which there cannot be more than 1 string to convert into a chart type.2. Can wpdatatable table/chart sync my google sheet data whenever i add new rows in my synced google sheet?Many thanks. 1,767Miloš repliedJuly 9, 2024 at 9:00pmHi lucas,If you wish to use this as numeric data in our Plugin - for example, in Charts as numeric series;You will need to remove any symbols and just have pure numbers in the source. But later you can easily add a prefix in our Plugin.Here are more details :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.2. Additionally, for decimal points, you can set the default decimal point in Main Plugin settings, as well as your Number Format.The decimal point can be changed per each column setting, though, if needed. 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 Sign in to reply ...
I have mainly two questions
1. I've tried syncing this google sheet onto wpdatatable, it has percentage & dollar value in it. Click here for google sheet.
2. Can wpdatatable table/chart sync my google sheet data whenever i add new rows in my synced google sheet?
Many thanks.
Hi lucas,
If you wish to use this as numeric data in our Plugin - for example, in Charts as numeric series;
You will need to remove any symbols and just have pure numbers in the source. But later you can easily add a prefix in our Plugin.
Here are more details :
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.![smile.png](https://assets.ticksy.com/app/_theme/shared_assets/redactor2/emoticons/emoticons/smile.png)
2. Additionally, for decimal points, you can set the default decimal point in Main Plugin settings, as well as your Number Format.
The decimal point can be changed per each column setting, though, if needed.
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