I have a question about field specific logic capabilities. Example: Can I have a cell (not a column) show or not show data based on the content of a cell in another column. So if I have a date column and an amount column, I would like the amount cell to be blank if the date cell in the same row is blank. Otherwise, the amount cell would display the predefined content. I know there is conditional formatting but that is not really helpful in this scenario. The key would be for cell specificity versus the entire column.
Unfortunately we do not have feature like this built in at the moment. If you just want to hide some values in the frontend and you are skillful with code you could possible do it with JavaScript. If you are using standard table preview (and not Excel-like) frontend engine behind the scene is Datatables jQuery plugin. They have built in callbacks which allows you to manipulate the data like - rowCallback. Our plugin renders standard HTML table in the fronted so any solution which will remove data from one cell based on the data in other will work
Thanks for the really quick reply Miljko. In reference to your mention of Datatables jQuery plugin, are you saying that it is possible to use the plugin in parallel with the WPDataTables plugin to accomplish this additional functionality or that Datatables jQuery plugin is already being used as the frontend engine and that it is what can be manipulated using JS? Sorry if this is a silly question, I just want to make sure I understand you completely.
Sorry for not gave you a clearer answer in the first place. I meant that Datatables is already being used as frontend engine and it can be manipulated from the frontend with JS by using their built in callback function or vanila JS
Based on data source that you plan to use it can depend what would be more appropriate for conditional showing of data but in most cases JS developer should be able to do it.
We are offering customization services for our customers for both JS as well as PHP tasks (and some more :-))
I have a question about field specific logic capabilities. Example: Can I have a cell (not a column) show or not show data based on the content of a cell in another column. So if I have a date column and an amount column, I would like the amount cell to be blank if the date cell in the same row is blank. Otherwise, the amount cell would display the predefined content. I know there is conditional formatting but that is not really helpful in this scenario. The key would be for cell specificity versus the entire column.
Thanks in advance!
Hi Randy,
Thank you for your inquire.
Unfortunately we do not have feature like this built in at the moment. If you just want to hide some values in the frontend and you are skillful with code you could possible do it with JavaScript. If you are using standard table preview (and not Excel-like) frontend engine behind the scene is Datatables jQuery plugin. They have built in callbacks which allows you to manipulate the data like - rowCallback. Our plugin renders standard HTML table in the fronted so any solution which will remove data from one cell based on the data in other will work
Thanks for the really quick reply Miljko. In reference to your mention of Datatables jQuery plugin, are you saying that it is possible to use the plugin in parallel with the WPDataTables plugin to accomplish this additional functionality or that Datatables jQuery plugin is already being used as the frontend engine and that it is what can be manipulated using JS? Sorry if this is a silly question, I just want to make sure I understand you completely.
Thanks again Miljko!
Hi Randy,
Sorry for not gave you a clearer answer in the first place. I meant that Datatables is already being used as frontend engine and it can be manipulated from the frontend with JS by using their built in callback function or vanila JS
Hi Randy,
Based on data source that you plan to use it can depend what would be more appropriate for conditional showing of data but in most cases JS developer should be able to do it.
We are offering customization services for our customers for both JS as well as PHP tasks (and some more :-))