Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2700964
Data to display breakage
Closed

Comments

  • Donny Lairson started the conversation

    None of the data in the database has comma's or .00 intergers

    The data on the table is adding periods where there shouldn't be and extra .00 to the end of SOME data.

    I would like the 1000's comma's added by your software without .00 on end.

    Also in the formula bar for the table. I would like to be able to multiple or do other math based on a php $global that i set via a shortcode from other plugins and or hard code.  I.e they have bought game gear that reduces the food requirement by 2m plus 10%  and then the outcome shoudl NOT display below zero.  so some prehelp in that would be nice.

  • Donny Lairson replied

    IF i turn off the 1000's separators the periods and the comma's go away.  Why its mixing them seems like the weirdest bug ever.

  • Donny Lairson replied

    Ok I found the Global setting.  BUT.  Global settings should not override my individual table customization.  So it was not an area I checked first.  As for my other stuff.  Clarity on how to reduced a Row number with a preloaded short code is still a bit unclear. It seems simple but then not as i want to do it for the column and the examples are cell formated.

  • Donny Lairson replied

    https://rogersraiders.com/guns-of-glory-academy-resource-requirements/

    The Tool bar for the users doesn't inclue my prefix and postfix information.  I put this into the table specifically so competitors can't just cleanly copy my data from my site straight to their database.  I at least want them to have to filter the data 

  • [deleted] replied

    Hi Donny

    Thank you for reaching out to us.

    Could you please explain to us in more detail what you are trying to achieve, if you could send us a screen recording that would be the best, or some screenshots so we can understand more clearly.

    When it comes to table tools we are using a third party library which has some limitations, please have a look at our documentation for more information.

  • Donny Lairson replied

    I have the paid version,  

    Data is not clean when presented from Mysql.

    If i want to do math BEFORE it is presented the mysql can do this but your interface has "custom" mysql language use.

    Trying to do math in line Can be done

    but if that result is a negative number and i want it represented as a Zero that Can't be done.

    Yes I am away i can do it in your interface BUT then the Tool bar outputs don't use that normalization so anyone who takes a pdf copy gets the negative numbers or anyone other customization of the math is wiped as well.  Making my product UNSHAREABLE.

    Also there is no watermarking to my website on the tool bar output. For website and/or contact info i would like to TRAVEL with the shared information.

  •  471
    Isidora replied

    Hi Donny,

    Blaženka is out of the office today and I will help you out.

    You can take a look at our documentation about Actions and Filters which are defined in wpDataTables plugin for customizations by developers.

    You will find a lot of useful hooks like filtering MySQL query or filter data for each column type.

    Table tools are created from third party library and there is some limitation that you can check on this link.

    Best regards.

    Kind Regards, 

    Isidora Markovic

    wpDataTables: FAQFacebookTwitterFront-end and back-end demoDocs

    Amelia: FAQFacebookTwitter |  Amelia demo sites | Docs

    You can try our wpDataTables add-ons before purchase on these sandbox sites:

    Powerful FiltersGravity Forms Integration for wpDataTablesFormidable Forms Integration for wpDataTables