Okay
  Public Ticket #3335865
Table Values = 0
Closed

Comments

  •  1
    Tony Fitzpatrick started the conversation
    March 29, 2023 at 3:16pm

    Hi, My website isn't live yet so I cant show you the problem on a live page

    I created a data table by importing data from a data source. - Google Sheets

    It pulled in 4 columns (Text, Text, Number, Number) 

    I configured them at String, String, Integer, Float

    When I view table in Standard/Excel view the numeric values have all gone to zero. See attachment

    I must be missing a step or configuring something incorrectly - any assistance much appreciated

    Regards

    Tony

    Attached files:  table.JPG

  •  1,849
    Miloš replied
    March 31, 2023 at 12:08pm

    HI, Tony.

    Sorry for the delay.

    Can you check, in the source data of the Sheet,  do you maybe have the currency symbol combined inside the numeric cells?

    If that is the case, please remove any suffix/prefix symbols from the source Sheet data,

    because in order to pass numeric data,  our plugin needs to  "see" pure numerical data from the source;

    then later in the plugin, you can go in each column settings, and in Display Tab you can add any suffix/prefix you need.smile.png

    Let me know if that was the case?

    -

    If not, can you send me URL to this source Sheet and share access to the Spreadsheet with my Email, then i can inspect the Source Data for you?

    My Email is [email protected].

    If the Sheet has any sensitive data, just send reply as PRIVATE, for safety reasons.

    Let me know how it goes. Thanks.

    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

  •  1
    Tony Fitzpatrick replied
    March 31, 2023 at 1:15pm

    Hi Milos

    I stripped out the formatting and prefixes and it solved the problem

    Its a great plugin - takes a bit of figuring out but its good.

    Thanks

    Tony

  •   Miloš replied privately