When I'm doing conditional formatting... replace (in my case) DRELE by Ph.D. on the wpDataTables side. Now on from the web site if people are searching Ph.D. they will find nothing... they must search with DRELE (the real value of the cell. is there a way to make the conditional formatting changed searchable ?
Unfortunately no, because Conditional Formatting is replacing in your case DRELE with Ph.D on the front-end and it is not changing table data actually. Search is not able to find Ph.D in the table because it is not value in the table just string that replaced actual value.
Dear Milos, thank you for your response, i'll make my script changing values in the CSV directly.
another question : I'm trying to do basic a basic horizontal bar chart, is there a way to do conditional formatting for integration color in that chart ?
Unfortunately something like that is not possible with built in functionalities, but if you are skillful with jQuery it can be accomplished with some custom coding. You can use wpDataCharts callback to apply options to chart that are not available out of the box - Link. You will have to apply colors by VALUE column condition. You can take a look at this JSFiddle what option for color you should apply - Link. If you need our assistance we can offer you our paid customization service.
Hello, thank you for this marvelous plugin !
When I'm doing conditional formatting... replace (in my case) DRELE by Ph.D. on the wpDataTables side. Now on from the web site if people are searching Ph.D. they will find nothing... they must search with DRELE (the real value of the cell. is there a way to make the conditional formatting changed searchable ?
Thank you !
Hi jsdecarie,
Thank you for your purchase
Unfortunately no, because Conditional Formatting is replacing in your case DRELE with Ph.D on the front-end and it is not changing table data actually. Search is not able to find Ph.D in the table because it is not value in the table just string that replaced actual value.
Dear Milos, thank you for your response, i'll make my script changing values in the CSV directly.
another question : I'm trying to do basic a basic horizontal bar chart, is there a way to do conditional formatting for integration color in that chart ?
in the following example : http://test.grames.polymtl.ca/facilities/servers-information/#servers
The data tables show clearly in RED the server that is the most use, but I would like to get that color chart within the bar chart below.
Hi jsdecarie,
Unfortunately something like that is not possible with built in functionalities, but if you are skillful with jQuery it can be accomplished with some custom coding. You can use wpDataCharts callback to apply options to chart that are not available out of the box - Link. You will have to apply colors by VALUE column condition. You can take a look at this JSFiddle what option for color you should apply - Link. If you need our assistance we can offer you our paid customization service.