You can't use test2 column in a formula column because it is a "string" type column. I mean - you can, but the result won't be correct, as you can see.
It doesn't matter if you add numbers with conditional formatting, since the table's type in the database is saved as string, so formula column's cannot use it properly for calcluations.
Hello,
I would like to create a conditional calculation table.
I would like a checkbox system or a "yes" or "no" system.
A checked box = € 15.50
Two or three boxes checked = 30 €
With the total at the bottom
Here is an example on Excel
And if all can become a product linked to woocommerce it would be great! : D
Hello Clément
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
Conditional logic works only for a single column, and adding conditional logic between columns is not possible with wpDataTables.
Also, we don't yet have integration with WooCommerce, so you couldn't link the table to a product.
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
Hello, thank you for your answer !
I found a roundabout way to get what I want.
My problem is that in my calculation column the formula will search for information without the conditions.
I can't figure out how to make the formula column search for information after the conditions.
Attached is an example image.
Thank you in advance !
Hi Clément
You can't use test2 column in a formula column because it is a "string" type column. I mean - you can, but the result won't be correct, as you can see.
It doesn't matter if you add numbers with conditional formatting, since the table's type in the database is saved as string, so formula column's cannot use it properly for calcluations.
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
Hello, thank you for your answer,
I do not understand why the conditional value does not appear in the excel file?
Is there a configuration to do?
Thank you in advance for your reply
Hi again Clément
Unfortunately, that's one of the limitations of table export tools - Conditional formatting is not reflected in any of generated export files.
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