tms-plugins

tms-plugins supports this item

Supported

This author's response time can be up to 5 business days.

1973 comments found.

Can wpDataTables automatically populate a column with the email address of a logged-in user?

Imagine an inventory tracking table. Logged-in users add/edit rows of data. I want an “email” column, where their email address is automatically populated without them having to type it.

Can wpDataTables do that? Is that the placeholder functionality? Maybe using CURRENT_USER_ID (but this seems to be a numeric ID, not an email address).

Hi there, thank you for the purchase,

wpDataTables itself doesn’t have a placeholder like that, but you can use an INNER JOIN with wp_users table in the query for the table where you display the entered data, so that you would always see their email address there.

Thanks!

HI there i recently purchased the wpDatatables plugin cause was the only way to solve a need i have for my website (its because Eforms plugin cant customize display of data submitted by users ) so i bought it but while im testing and perparing my website

So I have some observations

1.- Columns lack of a custom renderers for (strings, Urls, custom HTML code etc ) x cell / column which can be set in the datatables plugin 2.- Date formats cannot be customized on column settings only via MYSQL 3.- URL links are very complicated i order to set mine to work i had to use CONCAT as linktouse cause if i setted ||see request on “Display text after never worked 4.- someway to render HTML in cell values like templates linked with values. 5.- To be able to SET customized css or JS for TABLE and not Globally , i mean globally its ok but example in one page with 2 tables so i want to set on one table with search field and another table i dont want it no so it could be nice to set settings per table.

do you have considered these point for future releases ?

keep up the good work!

Hi there, thank you for your purchase, and for the kind words! Sorry for the delayed reply.

1) Not sure what do you mean here – there are multiple possible column types that can be used to render the cells differently. 2) There is a date format selection in the settings page. 3) The “two sticks” should work, but if you tried to put these in the ‘display text after’, then it wouldn’t work, it should be in the data source already. Otherwise if you want to display text different from the URL itself, some kind of separator format (like two sticks) would be necessary, especially for MySQL-based data. 4) Not exactly sure what do you mean, if you have HTML in your data source it should render properly. Also there’s a workaround to use conditional formatting (it can override the cell’s content). 5) In such cases we usually do it on the page with the table directly, e.g. Visual Composer and other page builders allow inserting JS blocks in the page.

Thank you for the suggestions, we will digest this and add to idea list.

Cheers!

Hi! Few pre-sale questions… Is it possible to change the whole row’s background color instead just a single column background on the conditional formatting section? Lets says if status column is “cancelled” the whole background would be red if status column is “on hold” the row would be yellow. Is there a fixedHeader feature? Any demo for invoicing purposes?

Hi there, thank you for your inquiry, and sorry for the delay,

1) Yes, it is possible to color the whole row (or whole column too). 2) Fixed Headers unfortunately aren’t currently supported. We used to have them, but it was causing too much trouble with different themes, so we discontinued it for now, but we are looking into re-implementing it again. 3) Unfortunately no invoicing demo – what exactly is the use case?

Thanks!

globalser

globalser Purchased

Hi!

3 Issues…

1 – When inline editing is activated, for a specific column i can only inline edit some cells (only the ones that have content, if the cell is empty i can inline edit all of them)

2 – When importing from excel file, if the first column is empty the import fails to import all the row. That specific row appears empty.

3 – If i select to hide some columns on the FRONTEND (the eye icon), when i reload the page it’s not memorized, is there a way to resolve this issue?

The theme is Enfold running Wordpress 4.7.3

Thanks

globalser

globalser Purchased

4 – The “Return” carriage (i have a cell with 2 lines) is not imported (used excel import). It should have a
separating the 2 values so that it appears in 2 lines inside the cell and not 1. How can i solve this problem?

globalser

globalser Purchased

5 – Pressing ENTER when editing a value, does nothing. Shouldn’t it save the value like in Excel? Shift+Enter should cause a
inside the cell. Anyway to solve this?

Hi there,

Thank you for your purchase! Sorry to be redirecting you – for support requests please use our support portal: https://tmsplugins.ticksy.com/ – our support team will help you.

Thanks!

gregmc

gregmc Purchased

have latest version – filtering/search works fine when we don not enable front end editing – the moment we enable front end editing sort/filter returns no records.

any idea why?

Hi there, thank you for your purchase,

Not sure – please open a support ticket in our support portal: https://tmsplugins.ticksy.com/ – and please provide credentials to see the table, so that our support team could check and see the reason.

Thanks!

gregmc

gregmc Purchased

i tried seems my license code has expired -

aw2

aw2 Purchased

Hello,

I try to upload an excell sheet following this URL: https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-excel/

When I try to upload I get this error

new_dummy_table.xls Sorry, this file type is not permitted for security reasons.

I tried another way: Via FTP I uploaded it to http://www.testdomain.com/download/new_dummy_table.xls

I get this error

wpDataTables backend error: Provided file http://www.testdomain.com/download/new_dummy_table.xls does not exist!

Do you know a way to solve this so I can use the templates

Hi there, thank you for your inquiry,

Do you have WP 4.7.3 ? There was a problem in WP 4.7.2 not allowing Excel and CSV uploads, here’s the fix: http://pixert.com/blog/wordpress-file-type-permitted-security-reasons/

aw2

aw2 Purchased

Great plugin!

I want 1 column with 100 rows. In each cell is a number. On the bottom of the row I want an average of all the number How to get this calculation in the bottom and what is the code of the calculation?

Thank you so much!

Hi there, thank you for your purchase,

In the current versions average calculations isn’t supported unfortunately. We are adding this feature in version 2.0.

Thanks!

chemchem

chemchem Purchased

Hello Is it possible to populate a WPDataTable with a query on an external database (NOT the WP database) Thank you !

chemchem

chemchem Purchased

Great !! Thank you for fast reply i’m searching in the documentation..but i dont see anything about it (may be JSON or data from php ?)

chemchem

chemchem Purchased

oh find in wpDataTables settings….I buy thks

chemchem

chemchem Purchased

Just a first feeback… I bought the plugin and 3 minutes later I have a fully functional table powered with our company data… Great plugin !!!

michelegb

michelegb Purchased

Prepurchase question:

I want to show a google spreadsheet containing sales and such of different departments. Then display them as a graph showing the total sales in comparison with the sales target.

1. Will editing the table update the spreadsheet? 2. Will editing the table update the graph?

These features would be mandatory and no googling helped me to figure this out and it cant be tested in the lite version..

michelegb

michelegb Purchased

Found the answer in your videos. It does refresh, but google cache is a little slow, perfect!

jpw94

jpw94 Purchased

Is it normal for the data to take a LONNNNGGGG time to load form Google Sheets?

martin16a

martin16a Purchased

Hi:

A year ago I ask the following:

” There is a little bug with the plugin.. any field that has the greater symbol ”>” cuts the word after the symbol example:

You guys fixed it. However, you have not fixed for the less symbol ”<” I dont have access to create a bug ticket as my support has expired. Now, as this is not support can you please provide a fix for this?

Thanks.

gianbizz

gianbizz Purchased

Hi, I tried to add a tooltip on the table for some column using CSS. The tooltip is work but the problem is tooltip appear inside the cell, so it does not appear perfectly, tooltip cut/trimmed by it cell. I have tried use “z-index” but not working. How to make the tooltip show out from the cell, so it will show full.

trg2017

trg2017 Purchased

Hi,

I have a query with the wpdatatables plugin. I have made several entries in the table but when i visit the table from frontend then it begins to load and nothing could happen.

Also I want the table to show colouring, so for that I have given the condition but the table is not showing the colour.

Please provide me a quick solution to these problems.

Regards Tanveer

by
by
by
by
by
by