I'm having few issues / have some questions. Any help will be appreciated.
Is there a way to autofill a column based on another column of the same table? In a front-end editable table, I want the user to select one of the value from the list in column A and based on that selection, the value in column B should change. The user is selecting a string in Column A but I need an integer to be use in a formula, so I was thinking if that selection in column A can auto-populate an integer value in column B, which I can then use in a formula.
In a formula column, I don't see a way to enable calculation function. I need to put the total sum like its possible in a normal integer column.
Does formula work on data from another table. I have a main table which has a list of order and I want to add all of them and simply display the total order value out side the table on the same page. The idea is that the total should be bold on the page to tell the end-client that the total order value is this much, and then the table below on the same page will have the breakup of all the orders.
The general settings have a color setting but thats applicable to all the table. How can I change colors/fonts of one single table instead of all?
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
There are no conditional editing options between columns. You can only add some Conditional Formatting for values in a column, but not between columns.
2. Unfortunately, like noted in our documentation, using calculation functions in formula columns is not possible.
3. I'm not sure I understand the question. If you're using the Foreign Key feature to pull the data from another table, Formula columns will not work because foreign key columns are basically "String" type columns, and their data can't be used in formulas.
4. Changing the colors of individual tables can be done only with some custom CSS. We will work on adding new options, so you can style tables individually, but I can't say when that will be included in the provided features of the plugin.
Hi,
I'm having few issues / have some questions. Any help will be appreciated.
Thank you!
Hello Saulat
Thank you for your purchase.
1. I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
There are no conditional editing options between columns. You can only add some Conditional Formatting for values in a column, but not between columns.
2. Unfortunately, like noted in our documentation, using calculation functions in formula columns is not possible.
3. I'm not sure I understand the question. If you're using the Foreign Key feature to pull the data from another table, Formula columns will not work because foreign key columns are basically "String" type columns, and their data can't be used in formulas.
4. Changing the colors of individual tables can be done only with some custom CSS. We will work on adding new options, so you can style tables individually, but I can't say when that will be included in the provided features of the plugin.
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