3623 comments found.
Hi, I am really interested in the plugin, just want to make sure it fits my needs.I already have a MySQL database hosted in some server storing business records. I would like to be able to connect to my database, create different forms for users to update that database and create different views of my db to display on different pages.Can you confirm that this is possible ?
Hello,
Yes, what you described should be possible with our Plugin, it just depends on a couple of details/points, what is needed exactly.
1. For adding an additional/external Database connection, you can do this ( For MySQL, MS SQL, Postgre SQL), please check out this feature here : https://wpdatatables.com/documentation/table-features/multiple-db-engine-connections-support-mysql-ms-sql-postgre-sql/.
2. You can then call SQL Query based tables from that Database and view the data in our Tables (https://wpdatatables.com/documentation/creating-wpdatatables/creating-mysql-based-wpdatatables/).
3. When it comes to setting up ‘different forms for updating of the data’, I am not sure what exactly is needed for that point.
You can check out all our editing options here, but please note the editing limitations from that Documentation, too : https://wpdatatables.com/documentation/front-end-editing/creating-editable-tables/.
- Only one MySQL table can be edited at a time. Queries from multiple tables with joins cannot be used as an editable feature, since SQL UPDATE and INSERT statements are generated automatically, and there currently is no way to update multiple tables.
– Only MySQL tables or tables created with “Create a table manually” and “Create a table by importing data from data source” options of “Create a Table” page can be edited.
- Server-side processing MUST be turned on for front-end editing – Note: It will turn on automatically if you forget to enable it.
– MySQL Views cannot be edited properly – only one of the underlying tables can be edited if you pass the proper ID.
We additionally have this inline editor and popover tool : https://wpdatatables.com/documentation/front-end-editing/inline-editing/.
So you can check out the available editing options for SQL Query based tables on these Pages – just take note of those limitations to be aware of.
4. ‘Create different views of my db to display on different pages’ :
We have various ways to pre-filter our tables for different pages.
For example, you can use these dynamic placeholders to make dynamic Queries(https://wpdatatables.com/documentation/table-features/using-placeholders/).
As you can see from that Documentation, this will allow you to set up one or more variable placeholders, then you can pass different filter values per each table shortcode as needed for different pages, etc.
Or, if you don’t add the condition in an SQL query, you can add variable placeholders like VAR1 in column settings -> Filtering, under “Predefined filtering value”.
Then, you can have different versions of the same table, with the VAR1 value passed in the shortcode.
We also have URL pre-filtering : https://wpdatatables.com/documentation/table-features/global-search-via-url/.
You will be able to test the premium Plugin on our Demo (https://sandbox.wpdatatables.com/) before purchase.
If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello, Can graphs be generated on the front end based on the user selections in the table filter options? I need this feature.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
I am not sure we understood your use-case exactly.
1. If you wish to create a new Chart from the Front-end, this is not currently possible in any way.
Each new Chart has to go through the steps of our “Create a new Chart” Wizard and it can only be done on the back-end.
2. Or, if you just wish to have some filters with a table on front-end, then have the Chart follow the filtering, to only show the filtered data of the table ‘on the fly’, we have this option as “Follow table filtering”. Please check more here : https://wpdatatables.com/documentation/wpdatacharts/follow-table-filtering-in-charts/.
If you require any assistance or have any additional questions about this, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
We purchased your plugin through your website and submitted a support ticket, however, our support login credentials do not work after creating the initial ticket. We’ve attempted to do a password reset, however, we never receive the email (not in spam). We then registered a new email to submit a ticket about the login issues, then logged out and tried logging back in with the new credentials and still could not log in and still no password reset email. This is why I am commenting here, as I am unsure how to access support at the moment.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
The best way to resolve this is, if you can please open a new private pre-purchase category ticket ( on a new Email again, if you can’t access any of the old attempted Email accounts) on our Main Support by clicking here, and send us any details about your licence purchase there, such as which Email you used for the licence purchase, if you have any invoice information, and make sure to leave a contact Email there which we can use to contact you directly via Email, and our agents will contact you that way to assist you with more details, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Can financial formulas in Google sheet be used? For example, can the following formulas be used?
https://support.google.com/docs/answer/3093281?hl=trHello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
We are not very familiar with those specific formulas, but if you can make them work on your source Google Sheet, then you should be able to create a table linked/synchronized from this Sheet source.
Please check out this Guide which shows how you can use Google Sheets with Formulas to build linked tables in our Plugin and avoid issues : https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/creating-tables-wordpress-google-spreadsheets-formulas/.
You can test building a Table from your Google Sheet on our Demo Site before purchase : https://sandbox.wpdatatables.com/.
If you require any assistance or have any additional questions about this, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
A very important question that is very important to have an answer to before purchasing.
When working with Google Sheets, is it possible to display different Lists. In the description I didn’t find the possibility to display different lists from the same spreadsheet. Usually, large tables very often use different lists to store data. For example on one list the list of customers, and on the other the goods or orders. But all this in one file. Thank you very much for your reply.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
In regards to your use-case, I am not sure if we understand it correctly.
Do you mean to have one large Google Spreadsheet which has multiple Tabs, so each Tab has a different ‘data set/list’?
If you plan to make one Table from each Tab of that Sheet, that is possible, because each Tab has a unique URL.
So, you would make one Table in our Plugin connected/synced from each individual Tab of your Sheet.
2. But if you need to use multiple Sheets from the Spreadsheet as one data source for one/same Table, that is not possible in our Plugin.
Each Sheet Tab can only be connected to one Table.
You can certainly test creating a Google Sheet table from your source Sheet on our Demo Website here : https://sandbox.wpdatatables.com/.
So you can basically test the full/premium functionalities on the Demo Site before purchase.
You can also check our Documentation/Guide on how to build tables from Google Sheets here : https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/.
Now, we do have multiple ways to have one large table which can store a lot of various different data, and you can pre-filter it differently for different Pages, for example.
Also, if you switch to SQL based tables, you could import your data into one large Manual Table;
Then you can make multiple SQL Query based Tables from that source Manual table and you can call different columns per each SQL table, different filters, limitations for users, and so on… If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I have a question.
I’m using ACF to store data on each product page.
Using the WPDB query generator, I was able to create a table by selecting the Products meta key, but when I paste the shortcode on each page, the data for the entire site is displayed.
Instead, for example, when I paste the shortcode for product A, I want only the custom field data related to product A to be output in the table.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Our Support is limited when it comes to troubleshooting custom SQL Queries such as pulling data from custom fields/posts and similar, such as ACF data, but we will do our best to see what we can do to help you isolate that issue.
We will not be able to go into more details here, because we need to see your page, table, how you setup everything, etc.
So, if you can please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there.
Once you open the ticket there, on the main Support platform, please show our Support more details, such as how your source table looks on the back-end, what kind of Query you are using, how you are implementing the shortcode on the Page, and so on.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello. I want to buy your plugin but I am interested in the possibility of its functionality. It is necessary to make such functionality on your plugin https://edata.e-health.gov.ua/e-data/dashboard/pmg-services-map
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
In regards to the functionality for your use-case, I am not sure what you mean exactly, because there are several elements to choose from on that Page.
1. For example, if you mean to have this Map exactly as from that example, which shows a lot of different details on it, such as multiple String column data passed on the Map, along with numeric data, etc, at the moment we do not have anything like that available.
When it comes to something ‘as close as possible’, we only have these GeoCharts available as part of our GoogleCharts. They are Region GeoChart, Marker GeoChart and
You will see examples of our Google GeoCharts on this Post: https://wpdatatables.com/wpdatatables-6-0/.
2. When it comes to the second example from that Site, which is a table that has Cascading filters above, we have this solution.
It can be achieved with our main plugin combined with our premium add-on Powerful Filters if you activate the “Cascade filtering” option.
Then each ‘next’ filter will be limited to only show the values associated from the previously selected filter.
Please check more here : https://wpdatatables.com/documentation/addons/powerful-filtering/.
If you have any further questions, please don’t hesitate to open a pre-purchase ticket on our main Support Platform here : https://tmsplugins.ticksy.com/.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
My website has both dark mode and bright mode compatibility. Does this plugin have this compatibility? So is it compatible with dark mode?
Hello,
Our Plugin does not have a ‘dark’ and ‘bright’ mode as native options to ‘switch between them’ if that is what you need.
We do have various table skins which you can choose from in the Customize section, and you can be very flexible when it comes to adding styling such as Custom CSS, etc;
but we don’t have ‘out of the box’ configurations which would allow you to set up ‘conditional styles’ such as ‘if I switch to Dark Mode on the Page, then change XY color to Z’, or similar.
That being said, if your Dark mode and Bright mode have some CSS which will override all colors on the Page, there is a chance it will also override our tables styles, but we can not guarantee it will work perfectly, since we have not tested something like that yet.
If you have an idea what we should add for that use-case, you can make a future development suggestion.
If you wish to see that in the future, you can make a development suggestion.
Please feel free to search on our suggestions page, to see if someone may be already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I just downloaded the newest version 6.5.3 via codecanyon and immediately Ninja Scanner listed /wpdatatables/assets/js/handsontable/handsontable.full.6.2.2.min.js as a suspicious file. The complained position can be translated back from the HexCode to handstable.com. But it should be handsontable.com?! handstable.com is obviously the wrong address, but I don’t have time to look through all the code now. Maybe this is correct? Could someone clarify this?
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
We are sending this report to our QA Team.
Our developers will also double-check what seems to be happening.
As far as we are aware, there should be no security risk on that file, this seems to be just a false positive result, but we will report back right away after double-checking.
Thank you for your patience. I will let you know if we require any further details from your end.
Hello,
We have feedback from our QA Team.
We did our best, but we are encountering various issues/errors coming from the Ninja Scanner Plugin on all our Test Sites, we can not use it to properly run any kind of scan.
Just to note, on all our Test Sites we have increased all the PHP Limits on our Servers to very high values; such as PHP Memory Limit at 1GB, TimeOut limit at 300 and so on.
We also tried different WordPress and PHP versions on the hosting servers with same result.
Even when we disable all other Plugins and use default WP Themes, the Ninja Scanner Plugin throws various errors, it can not start a scan.
On one Site we got a ‘critical error’, it can not activate itself.
On another Site, we can activate it, but when we try any kind of a scan, it throws ‘Missing lock file’;
On another Site, it throws a ‘fatal error as a Forbidden code’ and aborts the scan.
So as we are unable to use the Ninja Scanner Plugin to reproduce this on our end, if you wish, you can send us more details about that report you saw, does it show any more informations what exactly seems to be a security issue/or a vulnerability for handsontable.full.6.2.2.min.js?
If there is a report that can be exported, you can upload it to weTransfer and send us a download link, then we can pass it to our developers.
They can double-check it, but this is most probably just a ‘false-positive’ report, there should be no security issues with the said file.
Let us know what you decide to do next, our Support will be here.
Kind regards.
Hello again,
We spoke with our developers about this, they will investigate the file in full details to make sure that there are no security issues/vulnerabilities.
We can’t say an exact ETA since our Team is not at full capacity due to a vacation period, but the developers will look into it as soon as possible with high priority.
There should be no security issues since that file is only used at the back-end, but we will still conduct a full investigation.
Thank you for reporting it.
Hello,
We noticed a conflict between the Houzez template scripts and WpDataTables. When a shortcode with a WpDataTables table is embedded, after clicking on the template gallery ( https://prnt.sc/V0F6eh-F8VIb ), you cannot click anything and the page elements stop working. In the plugin settings, we have Bootstrap disabled for both frontend and backend ( https://prnt.sc/6c9fx_vMiA5D ), unfortunately this solution does not help. Can we get a hint on how you troubleshoot other scripts?
Hello,
Since you already tried disabling our Bootstrap and the conflict persists, then we are unable to advise without full access to the Page and to try and isolate the issue with our developers.
Our developers are usually able to quickly isolate what causes the conflict and to resolve it with Custom CSS/JS or by excluding a script if it cause the issue, etc;
Can you please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will ask you for the required access and if they need more details there, then our developers will investigate the conflict.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Thank you for your answer. When submitting a request, I receive information about the expiration of support. How can I purchase support only without purchasing the plugin again? Do I have to pay $257.25?
Problem solved, we added CSS code.
Hello,
When you purchase a licence from Envato, the premium support period is 6 months, and you will have the option to purchase an extended support to additional 6 months.
But after 12 months, your licence would stop being recognised on our Ticksy Support Platform, because there is no way to extend it further on the Envato version of the licence.
Envato was the only marketplace where you could purchase wpDataTables, but we’ve launched our own (TMS) store a few years ago. If you’re interested in the price difference between Envato and what you see on our website, as well as other features/benefits, please feel free to open a private pre-purchase category ticket on our Main Support by clicking here and our agents will gladly assist you with more details there, if needed.
When you choose the pre-purchase category, it will not make you insert any licence key.
The fact is that both Envato and our website have the same version of the plugin, as we’re uploading all updates to Envato as well. You don’t need to purchase anything. The $260 you see is the extension on support, but you are entitled to all upcoming updates as Envato market offers a lifetime license.
That being said, there are still some major differences between our Store and Envato, which you can ask in more details on our Main Support as mentioned above.
In regards to the issue, I am glad to see you solved it with CSS.
If anything new comes up, please don’t hesitate to reach out to us here, or on the Main Support, just open a private pre-purchase ticket there and send them your Envato licence key.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi,
Is your plugin compatible with bedrock?
Thank you.
Hello,
The plugin is compatible with most premium themes and page builders.
However, since there are tens of thousands of themes out there, and a hundred builders (which are all usually premium), we can’t guarantee that the plugin is 100% compatible with any theme or builder.
Especially in an environment such as WordPress, where developers freely and frequently change their code, logic, libraries, frameworks, etc.
We tend to resolve all conflicts as soon as they arrive, and if you encounter any, feel free to reach out to us via a Support ticket here (https://tmsplugins.ticksy.com/) and we’ll gladly help.
In most cases, these conflicts are easily solved with some custom CSS or adjustments in our plugin, or in the theme or the builder.
If you still don’t have a premium licence, I just wish to point out that you can try out our premium features before purchasing on our Demo Site (https://sandbox.wpdatatables.com/) and we have a 15-day money-back guarantee, so you can purchase it and fully test everything you need, our Support will be here to assist and as mentioned, our developers can usually quickly resolve any issues such as conflict with a specific Theme or Builder, etc, if it happens.
Let us know if you have any additional questions.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Sir, I want to create a page to create an online course programme for students. This course programme page will contain a table. This table will contain the syllabus I created. If the student wants, he/she will be able to change the syllabus I created.
https://ibb.co/pwnNskXStudents will only organize their own class schedule.
It will not edit the worksheet that the administrator has created as an example for students. Students will customize the study schedule just for them. I hope you understand what I mean.
Hello,
Firstly our sincere apology for the delayed reply. Thank you for your patience.
If you wish to have one main/master Table which will have all the data, for the Administrator – you can create, for example a Manual Table.
Then, for front-end users, you can create an additional SQL Query based Table which is going to pull the same data from the source Manual Table and it can be made editable – so any editing done on this SQL Table will reflect the source Manual table and vice-versa.
So the idea is to make the main Manual table without restrictions, which can be edited by the Administrator;
and on this additional SQL Query table which shortcode you can post on the front-end, it can have various limitations set on it for students, such as you can limit them to only see the rows associated to their user ID. Please check out this feature here : https://wpdatatables.com/documentation/front-end-editing/allowing-users-to-edit-only-their-own-data/.
But we are not fully understanding the last part of your use-case, where you wrote that the students can not edit the Admin’s table, they can only customize their own schedule.
Our Main Support Agents can advise you in more details, so can you please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
If you still don’t have a licence, that’s OK, you can still choose the pre-purchase ticket category and please elaborate in more details about that last part so the Main Support can fully understand it, for example, should the Admin have a different table – and then you can call some columns in the student table as a foreign key relation;
Just note that our Foreign Key column can only be limited to a single value selectBox, which pulls values respective from the foreign Table. Our Main Support can certainly advise you on this, too.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I have a table where I have, besides other columns, the columns Country, State and City. I am using a mysql view to load the table. When I select a Country, I then want the other selectboxes to update and show only the options based on the Country or Countries I’ve selected.
Is that even possible? I suppose there should be a way to achieve that.
Hello,
Yes, this can be achieved with our premium add-on ‘Powerful filters’.
It has a feature named ‘Cascade filtering’, which does exactly what you described, for example if you choose the first column filter as a specific Country, then the next column filter will only show the values associated to the States which ‘belong’ under that Country and hide the others.
Please check more details about this add-on here : https://wpdatatables.com/documentation/addons/powerful-filtering/
You can also fully test the add-on before purchase on this Demo : https://sandbox.powerful.wpdatatables.com/.
If you require any further details or if you encounter any issue when you start using this with your table, our Support will be available to help.
If that happens, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Sir, can I create something like this? Students will find out how many points they have scored by entering the number of questions they have solved.
» https://demo.juzkthemes.net/kampus/yks-puan-hesaplama/
1. Question: For example, the student will enter the number of questions solved in maths. Then he/she will enter the number of questions he/she got wrong in maths. In the bottom cell, the student will enter the total number of correct questions remaining. For example, in cell A1 there will be 10 (the number of questions marked), in cell A2 there will be 4 (the number of incorrect questions marked), in cell A3 there will be =A1-A2, i.e. 6 from 10-4.
2nd Question: Can we show as many columns as we want on the horizontal axis? For example A1, B1, C1, D1… Is it possible to have many columns side by side? Suppose there is 10 in cell A1 and 4 in cell B1. I want to print the result A1+B1 in cell C1 and the result A1-B1 in cell D1. Is this possible?
Hello,
Firstly, we apologise for taking so long to write this reply. We did our best to check all the relevant points to confirm them for your use case. Thank you for your patience.
I am truly sorry to disappoint you, but we do not have such advanced calculations available at the moment in our Plugin.
Currently, we have this Formula Column as you can see on this Documentation : https://wpdatatables.com/documentation/column-features/formula-calculated-columns/.
It can be used to combine multiple numeric columns in basic math operations with brackets, but nothing more advanced like your examples.
If you wish to see that in the future, you can make a development suggestion.
Please feel free to search on our suggestions page, to see if someone may be already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Is it possible for students to create a list of the departments they can prefer?
https://drive.google.com/file/d/1OW2V0aHCAT2bBikY7NjUqMQGbqbKRW_E/view?usp=sharingHello,
Firstly, we apologise for taking so long to write this reply. We did our best to check all the relevant points to confirm them for your use case. Thank you for your patience.
We can see that this example is extremely similar to the one from your previous request below.
It is the same answer as for the other example – we can see on this specific example, the only difference is the content, but the same ‘logic’/principle is used.
Some of the details are possible, while some other points are currently not available with our Plugin. We will cover the main/major points:
The filters above the Table:
We have this available – you can enable the option to set the column filters to render above the Table. You will see this in the Table’s filtering settings.
Additionally, if you wish to hide the table before the user chooses their filters and then hits “See results,” you can do this with our premium add-on Powerful Filters. It has the feature “Hide table before filtering.”
Please check more details about this add-on here: https://wpdatatables.com/documentation/addons/powerful-filtering/
You can also fully test the add-on before purchase on this Demo: https://sandbox.powerful.wpdatatables.com/.
We do not support merged cells:
We notice in some of the Headers of these Columns, for example, “Base point” is a merged title that comes across three cells of three Column headers like an “additional header layer” above.
This is currently not possible. You can only have merged cells in our Simple Table type, but this table type cannot have any filtering and has other major limitations, which are not suitable for your use case.
Lastly, the “Preference list” Column:
If we see it correctly, this is something similar to a ‘checkbox column’ in which a User can select one or more rows – then it says “Added to your preference list.”
We can see in your Video that this is saved above in the “preference list” container for further use and when you click in that list, that automatically generates a new table on another Page, which is then available for export.
At the moment, we do not have anything like that in terms of a checklist for users to select one or more rows, then ‘do some action’ with the selected rows.
If you wish to see that in the future, you can make a development suggestion.
Please feel free to search on our suggestions page to see if someone may have already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like (it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be the first to find out about new features, releases, plans, and promotions from the wpDataTables team.
Hello sir, I want to make a preference robot for students. Can I create an identical version of this table with your plugin?
Hello,
Firstly, we apologise for taking so long to write this reply. We did our best to check all the relevant points to confirm them for your use case. Thank you for your patience.
Some of the details are possible, while some other points are currently not available with our Plugin. We will cover the main/major points:
The filters above the Table:
We have this available – you can enable the option to set the column filters to render above the Table. You will see this in the Table’s filtering settings.
Additionally, if you wish to hide the table before the user chooses their filters and then hits “See results,” you can do this with our premium add-on Powerful Filters. It has the feature “Hide table before filtering.”
Please check more details about this add-on here: https://wpdatatables.com/documentation/addons/powerful-filtering/
You can also fully test the add-on before purchase on this Demo: https://sandbox.powerful.wpdatatables.com/.
We do not support merged cells:
We notice in some of the Headers of these Columns, for example, “Base point” is a merged title that comes across three cells of three Column headers like an “additional header layer” above.
This is currently not possible. You can only have merged cells in our Simple Table type, but this table type cannot have any filtering and has other major limitations, which are not suitable for your use case.
Lastly, the “Preference list” Column:
If we see it correctly, this is something similar to a ‘checkbox column’ in which a User can select one or more rows – then it says “Added to your preference list.”
We cannot see what that does exactly, but I presume this saves the information somehow to the user’s back-end details.
At the moment, we do not have anything like that in terms of a checklist for users to select one or more rows, then ‘do some action’ with the selected rows.
If you wish to see that in the future, you can make a development suggestion.
Please feel free to search on our suggestions page to see if someone may have already suggested this feature.
If you can’t see it, feel free to add your suggestion there, and as more people vote, the feature will move higher on the priority list.
You can certainly follow our changeLog page if you’d like (it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you’re informed about new features, bug fixes, freebies, etc.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be the first to find out about new features, releases, plans, and promotions from the wpDataTables team.
Is it possible to make a site like this full of calculations?
https://www.pexpe.com/saat-farki-hesaplama/Hello,
Firstly, our sincerest apologies for all the waiting time on this reply.
Sorry to disappoint you, but we do not have complex formulas like that available in our Plugin.
We have a Formula Column which can use basic math operations and combine multiple columns together; but we don’t have anything more complex such as Google or Excel formulas or these advanced formulas/ custom calculations as from your example.
You can check out more details on our current available Formula column capabilities here : https://wpdatatables.com/documentation/column-features/formula-calculated-columns/.
You can make a table linked from a Google Sheet with formulas, though.
Please try this method to link a Table from a Google Sheet with formulas as explained here : (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/creating-tables-wordpress-google-spreadsheets-formulas/).
If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I have a google sheet table. I used google finance queries very often in this table. Google finance data is updated every 15 minutes. Does this continuous updating process slow down the system? I can pull historical price data of apple company or data from 15 minutes ago. For example, with the formula = GOOGLEFINANCE , apple company’s data from 15 minutes ago can be pulled.
Now, is it possible to create the same table in your plugin?
https://docs.google.com/spreadsheets/d/1Xel7Hvm-bnkVwYl_hk61E0LQZnxQZ2AnKANjrLESSFA/edit?usp=sharingHello,
Our sincerest apology for all the waiting time on this reply, thank you very much for all your patience.
When it comes to using formulas or scripts in your source Google Spreadsheet;
Our Plugin itself does not have any formulas like that. We have a Formula Column which can use basic math operations and combine multiple columns together; but we don’t have anything more complex such as Google or Excel formulas.
You can check out more details on our current available Formula column capabilities here : https://wpdatatables.com/documentation/column-features/formula-calculated-columns/.
You can make a table linked from a Google Sheet with formulas, though.
Please try this method to link a Table from a Google Sheet with formulas as explained here : (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-google-spreadsheets/creating-tables-wordpress-google-spreadsheets-formulas/).
Just make sure you don’t change any Header names with Formulas, so each Column Header needs to reman with same Header name and it must keep the same column structure in order for our table to work.
If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I have a question about the Google sheet table. I have a table with 15-20 thousand rows and 25 columns. Can I import this table with the “Create a data table linked to an existing data source.” method?
Hello,
Our apologies for all the waiting time on today’s replies. Thank you for all your patience.
In regards to your question, you will not be able to use a table linked from an existing data source when there are so many rows.
It is because all these rows will be called in the browser’s HTML at the same time and WordPress along with your Hosting server can not handle so much data like that.
We do have this “Cache and auto update Cache” Feature, which can help with performance for linked tables, but this only helps up to around 5 to 6 thousand rows. When you have a larger data set than this, then we recommend to move to SQL based Tables, because then you get our server-side processing feature, which uses AJAX calls to only load one Table page at a time to reduce server load.
(https://wpdatatables.com/documentation/table-features/server-side-processing/)
But even when you try to import this to an editable (server-side) table, we can not import so many rows through WordPress, but there is a workaround solution. We will explain in more details :
In regards to importing the data via a file, data that has more than few thousand rows can sometimes not be imported in this way directly via the plugin ( depending on the server) – this is a limitation that is coming from WordPress itself combined with server performance.
There is a solution, though.
What you can do is, if you get errors, and it does not work importing directly through our plugin, you can then import the file, in form of Excel, CSV, or spreadsheet directly in your database via your database management tool, such as PhPMyAdmin.
And then you will be able to create a simple SQL Query based table from this imported database table, by using this query (for example):
SELECT * FROM table_1
This way, you will get good performance result in the end and the Page won’t be too slow or crash the browser, etc.
If you require any assistance or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Sir, can I set up a calculation system like this?
Users will enter some numerical data. Then that numerical data will be subjected to 4 processes in the background. and will show them the result. for example, suppose the user enters the value 5 in cell A1 and 10 in cell B1. In this case, is it possible to print the result of A1+B1 in cell C1?
https://puango.net/ https://ogmmateryal.eba.gov.tr/yks-puan-hesaplamaOr let’s say the user entered the data 75 in cell a1 and 10 in cell b1. I want to print the result of the a1-b1/4 operation in cell c1.
Is this kind of operation possible?
Hello,
Firstly, our sincerest apologies for all the waiting time, thank you very much for all your patience.
In regards to the use-case you asked, we do not have anything like this at the moment.
Right now, we have a Formula Column which can be used for basic math operations, but this formula goes through each row of data ‘one by one’ if that makes sense;
you can not use it to combine specific cells such as in that example.
If you wish more information on how our current Formula Column capabilities work, please check out this Documentation : https://wpdatatables.com/documentation/column-features/formula-calculated-columns/.
If you require any assistance for our currently built-in functionalities or have any additional questions, please open a private pre-purchase category ticket on our Main Support by clicking here, attach your Envato invoice, and our agents will gladly assist you with more details there, if needed.
If you wish to see improved calculation capabilities, you can make a future development suggestion on this Page https://features.wpdatatables.com/ and as more users vote, it raises the priority on that task for the developers. We can’t promise an ETA on it, but you can follow our changeLog during updates https://wpdatatables.com/help/whats-new-changelog/.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
