Hey everyone!

With the Labour Day holidays coming up, we’d like to let you know about our upcoming working hours:

Thursday, May 1st: Our team will be off during Labour Day.
Friday, May 2nd: We'll also be off for an extended holiday break.

We’ll be back on Monday, May 5th, ready to respond to all messages received during this time.

In the meantime, if you need help, feel free to:

https://www.youtube.com/@AmeliaWordPressBookingPlugin/videos

https://www.youtube.com/@wpDataTables/videos

Thank you for being so understanding, and we hope you enjoy the long weekend! 

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,894
    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