Okay
  Public Ticket #3681505
Syncing issue
Closed

Comments

  • lucas started the conversation

    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.

    • 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,846
    Miloš replied

    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)

    3329794335.png

    After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.

    7104814461.png
    3473824743.png
    4603617641.png

    Let me know if that helps.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

    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 | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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