This author's response time can be up to 5 business days.
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.
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.
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?
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
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?
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?
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.
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.
i tried seems my license code has expired -
When I try to upload I get this error
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/
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!
In the current versions average calculations isn’t supported unfortunately. We are adding this feature in version 2.0.
Is it possible to populate a WPDataTable with a query on an external database (NOT the WP database)
Thank you !
Hi, thank you for your inqiry,
Of course, it is supported, just 2 conditions:
1) It should be a MySQL database,
2) It should allow remote connections.
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 ?)
oh find in wpDataTables settings….I buy
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 !!!
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..
Found the answer in your videos. It does refresh, but google cache is a little slow, perfect!
Is it normal for the data to take a LONNNNGGGG time to load form Google Sheets?
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?
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.
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.
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $15.50
Unlimited graphic downloads & digital courses. Only $29/month
22,000+ templates & 1,000+ courses
Learn almost anything with
Envato Tuts+ for free
9000 free tutorials, 3000 paid courses
Designers matched perfectly to
you on Envato Studio
2000 artists ready to undertake your work