We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3335865
Table Values = 0
Closed

Comments

  •  1
    Tony Fitzpatrick started the conversation

    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

  •  1,894
    Miloš replied

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

  •  1
    Tony Fitzpatrick replied

    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