Hi, I am thinking of using the plugin. I tried it before a few years ago but it couldn't do a few things I needed, I am considering it again but need to know a few things first please.
1. My columns sometimes need an explanation about how to input the data (they are frontend editable per user). Is there no way, like a tooltip or smaller sub-heading, to add this description to a column heading?
2. Do you have conditional logic, like show column B if column A = yes?
3. Is it possible to show when a column is updated? Either in the backend, or the frontend or both?
4. I am looking to have a table which is updateable by users indefinitely, they should be able to add monetary amounts to the same cell when a client pays them more. I would like to either be able to show when this amount is updated, or add a date to this cell along with the monetary amount (maybe with your details addon?), or add multiple amounts and their date. Is this possible with wpdatatables itself and or with one of your addons? And if so how would it display that information?
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features. You can probably add it with some custom work, but it is not included in the provided support for the plugin, so we can't help you with that.
2. Conditional Formatting is only possible inside a column, and what you're looking for to achieve is not possible. There is no conditional logic between columns.
3. What do you mean? If you update a column, the change will be seen in the table. If you're looking at the table on two different pages, and you update it on one of those pages, the second page will need to be refreshed to see the change. Marking that change in some way, however, is also not possible, and it would have to be custom-developed.
4. People can edit the table as much as they want if you allow them to, but showing what's been updated and how (from what) is not possible. You can maybe add a timestamp column with a workaround:
For example, I created a simple manual table:
wdt_ID column is being automatically generated, and is usually hidden, but I've displayed it here for explanation purposes.
When I created a table, and added the first row, I could then modify it. So, in order to set the Datetime column to be auto-populated, I had to open the table in the database. It is being stored as wp_wpdatatable_6, and you can see its database name in Editing tab in the settings above the table:
Then, in PHPMyAdmin, I opened the table, and ran the following query:
After that, again in the Editing tab, above the table, I changed the "ID column for editing" from "wdt_ID" to "datetime" (as you can see in the screenshot above). Then I disabled editing for "wdt_ID" in the column settings:
datetime column, being the "ID column for editing" automatically cannot be edited, but is automatically filled.
You can also choose to hide it from view if you'd like.
Hi, I am thinking of using the plugin. I tried it before a few years ago but it couldn't do a few things I needed, I am considering it again but need to know a few things first please.
1. My columns sometimes need an explanation about how to input the data (they are frontend editable per user). Is there no way, like a tooltip or smaller sub-heading, to add this description to a column heading?
2. Do you have conditional logic, like show column B if column A = yes?
3. Is it possible to show when a column is updated? Either in the backend, or the frontend or both?
4. I am looking to have a table which is updateable by users indefinitely, they should be able to add monetary amounts to the same cell when a client pays them more. I would like to either be able to show when this amount is updated, or add a date to this cell along with the monetary amount (maybe with your details addon?), or add multiple amounts and their date. Is this possible with wpdatatables itself and or with one of your addons? And if so how would it display that information?
Thanks very much for your time.
Cheers
Tyrhone
Hello Tyrhone
Thank you for your interest in our plugin.
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features. You can probably add it with some custom work, but it is not included in the provided support for the plugin, so we can't help you with that.
2. Conditional Formatting is only possible inside a column, and what you're looking for to achieve is not possible. There is no conditional logic between columns.
3. What do you mean? If you update a column, the change will be seen in the table. If you're looking at the table on two different pages, and you update it on one of those pages, the second page will need to be refreshed to see the change. Marking that change in some way, however, is also not possible, and it would have to be custom-developed.
4. People can edit the table as much as they want if you allow them to, but showing what's been updated and how (from what) is not possible. You can maybe add a timestamp column with a workaround:
For example, I created a simple manual table:
wdt_ID column is being automatically generated, and is usually hidden, but I've displayed it here for explanation purposes.
When I created a table, and added the first row, I could then modify it. So, in order to set the Datetime column to be auto-populated, I had to open the table in the database. It is being stored as wp_wpdatatable_6, and you can see its database name in Editing tab in the settings above the table:
Then, in PHPMyAdmin, I opened the table, and ran the following query:
After that, again in the Editing tab, above the table, I changed the "ID column for editing" from "wdt_ID" to "datetime" (as you can see in the screenshot above). Then I disabled editing for "wdt_ID" in the column settings:
datetime column, being the "ID column for editing" automatically cannot be edited, but is automatically filled.
You can also choose to hide it from view if you'd like.
I hope this helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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