I need format a column wich depends on values of another one. I want that companies associated to order type "BUY" ("COMPRA" in spanish) are shown in green color, and the other ones associated to order type "SELL" ("VENTA" in spanish) are shown in red color.
Attached I send you two files when you can see how this is resolved in my old app (MS Access and VBA), and my current situation with wpDataTables.
Me pasa lo mismo, esta mañana he abierto un "ticket" en privado a ver si me solucionan el problema. Yo creo que tengo el problema, des de esta mañana que he actualizado a la última versión del Plugin, la 4.5. ¿Has actualizado recientemente?
pues no he actualizado el plugin todavía porque lo acabo de comprar solo hace unos pocos días. Estoy empezando a configurar mi primera tabla y ya me he encontrado unos cuantos problemas que voy solucionando poco a poco como puedo, aunque estoy aprendiendo a manejarme con la herramienta y le voy cogiendo "gustillo".
A ver si nos dan una solución a éste problema, aunque me temo que igual necesita algo de programación.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Currently, there's a bug with Conditional Formatting and Calculation Functions when it comes to using whole numbers in the headers.
Workaround is to edit the source file and change the header of a column from "1", "2", "3", etc. to "One", "Two", "Three", etc. and then modify the display header.
There's a bug created, but we don't know exactly when it will be fixed - our developers are doing their best, the fix should be a part of one of the future updates.
-
I can see you have given us an Administrator user credentials;
but i can't seem to find a link to your site/ WP Admin page anywhere?
-
Could you please send me a link to your WP-Admin, and point me to the table ID;
then i can inspect the issue for you , to make sure if it's the same one that we made a bug for.
Of course, if you send any sensitive information, please mark reply as Private.
In the meantime, i went through all the details from this ticket again;
i am sorry i didn't notice this right away - but, looking at the screenshots > is this how your table looks now?
Can you confirm - is the conditional formatting not working at all;
for example, if you set any simple condition, to change a color of cells in the same column, if a condition on that column is met?
-
It seems that you goal here, is to set a condition that will look for something in another column ?
If that is the case, then i am truly sorry to disappoint you - using conditional logic in our plugin can currently only look for the cell values from the same column > not from other columns.
-
You said :
I want that companies associated to order type "BUY" ("COMPRA" in spanish) are shown in green color, and the other ones associated to order type "SELL" ("VENTA" in spanish) are shown in red color.
Attached I send you two files when you can see how this is resolved in my old app (MS Access and VBA), and my current situation with wpDataTables.
-
I'm sorry, but i can't find that in this example.
If you can please elaborate more on what you mean, when you said that "companies associated to order type "BUY" ( "COMPRA" in Spanish) are shown in green.
Could you elaborate to explain this with a bit more details?
Sorry, but i am still unable to get to the page, i tried everything - other browsers, incognito mods..
But i will do my best to go forward with our query.
If i understood you - you wish that something from Column A, affects Column B, via condition.
Something like that is not possible with the current state of our plugin - maybe it will be possible soon in the near future.
I made a little example to show you the current behaviour for Conditionals.
If we make a simple table with 2 columns, like this :
And let's say we want the first column to change colors based on cell values.
Now, if we try to take any kind of value from Column 1, and take it as a condition in Column 2, we are not able to :
So the condition, "if cell value" > this will only look for cells in this column;
we can not search for any values from other columns.
Currently, we don't have any workaround to achieve that, as well.
-
Let me know if i understood the goal, or if you perhaps need to achieve something else. If you can take screenshots, or make a video to show us in more details;
Sorry, maybe you are unable to get the page because we work on different netwoks, and communication between both is not allowed to access between one and the other.
I have tried to access in all these ways and I have been able to access without problems.
Respect to conditional format, it looks like the format of a cell depends only on the values of itself, not on the values of another.
I have thought that maybe the solution could be in a hook like this I send you attached.
Although it doesn't work now, take a look and tell me what is your opinion about it.
To clarify, ColID=1 is the column I want to get colored, and ColID=4 is the column with the conditional values "COMPRA" and "VENTA".
I have found a much easier and more elegant solution to the conditional formatting problerm. It consists of a combination between the CASE and CONCAT functions, its form is as follows:
SELECT CONCAT('<a href=/wp.wpdatatable_2 style=color:white>', A.COD_ESTR, '</a>') AS COD_ESTR, CASE A.TIPO_OP WHEN 'COMPRA' THEN CONCAT('<wp.wpdatatable_2.td style=color:#009B00>', A.DESCRIPCION_TICKER, '</wp.wpdatatable_2.td>')
WHEN 'VENTA' THEN CONCAT('<wp.wpdatatable_2.td style=color:red>', A.DESCRIPCION_TICKER, ' </wp.wpdatatable_2.td>')
END AS DESCRIPCION_TICKER,
A.MERCADO, A.DESCRIPCION_MERCADO, A.TIPO_OP,
You can see the final result in the attached file.
Hi all,
I need format a column wich depends on values of another one. I want that companies associated to order type "BUY" ("COMPRA" in spanish) are shown in green color, and the other ones associated to order type "SELL" ("VENTA" in spanish) are shown in red color.
Attached I send you two files when you can see how this is resolved in my old app (MS Access and VBA), and my current situation with wpDataTables.
Best regards
Francisco Gutiérrez
Hola Francisco,
Me pasa lo mismo, esta mañana he abierto un "ticket" en privado a ver si me solucionan el problema.
Yo creo que tengo el problema, des de esta mañana que he actualizado a la última versión del Plugin, la 4.5. ¿Has actualizado recientemente?
Un saludo.
Hola Fermí,
pues no he actualizado el plugin todavía porque lo acabo de comprar solo hace unos pocos días. Estoy empezando a configurar mi primera tabla y ya me he encontrado unos cuantos problemas que voy solucionando poco a poco como puedo, aunque estoy aprendiendo a manejarme con la herramienta y le voy cogiendo "gustillo".
A ver si nos dan una solución a éste problema, aunque me temo que igual necesita algo de programación.
Un saludo cordial
Francisco
Hello Francisco,
Thank you for reaching out to us.
Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, Francisco
If you are having the same issue as Fermi;
Currently, there's a bug with Conditional Formatting and Calculation Functions when it comes to using whole numbers in the headers.
Workaround is to edit the source file and change the header of a column from "1", "2", "3", etc. to "One", "Two", "Three", etc. and then modify the display header.
There's a bug created, but we don't know exactly when it will be fixed - our developers are doing their best, the fix should be a part of one of the future updates.
-
I can see you have given us an Administrator user credentials;
but i can't seem to find a link to your site/ WP Admin page anywhere?
-
Could you please send me a link to your WP-Admin, and point me to the table ID;
then i can inspect the issue for you , to make sure if it's the same one that we made a bug for.
Of course, if you send any sensitive information, please mark reply as Private.
Thank you
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Miloš,
Try it again with this link:
https://patronesfinancieros.com/wp-login.php
Kind regards
Francisco
Hi, Francisco
Sorry for the delay
Unfortunately it is still the same.
If i try Wp-Admin page - https://patronesfinancieros.com/wp-admin , i got the "locked" error;
but if i try the WP-Login page that you sent https://patronesfinancieros.com/wp-login.php,
i got a different error : 502 Bad Getaway
-
In the meantime, i went through all the details from this ticket again;
i am sorry i didn't notice this right away - but, looking at the screenshots > is this how your table looks now?
Can you confirm - is the conditional formatting not working at all;
for example, if you set any simple condition, to change a color of cells in the same column, if a condition on that column is met?
-
It seems that you goal here, is to set a condition that will look for something in another column ?
If that is the case, then i am truly sorry to disappoint you - using conditional logic in our plugin can currently only look for the cell values from the same column > not from other columns.
-
You said :
I want that companies associated to order type "BUY" ("COMPRA" in spanish) are shown in green color, and the other ones associated to order type "SELL" ("VENTA" in spanish) are shown in red color.
Attached I send you two files when you can see how this is resolved in my old app (MS Access and VBA), and my current situation with wpDataTables.
-
I'm sorry, but i can't find that in this example.
If you can please elaborate more on what you mean, when you said that "companies associated to order type "BUY" ( "COMPRA" in Spanish) are shown in green.
Could you elaborate to explain this with a bit more details?
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi, Francisco
Sorry, but i am still unable to get to the page, i tried everything - other browsers, incognito mods..
But i will do my best to go forward with our query.
If i understood you - you wish that something from Column A, affects Column B, via condition.
Something like that is not possible with the current state of our plugin - maybe it will be possible soon in the near future.
I made a little example to show you the current behaviour for Conditionals.
If we make a simple table with 2 columns, like this :
And let's say we want the first column to change colors based on cell values.
Now, if we try to take any kind of value from Column 1, and take it as a condition in Column 2, we are not able to :
So the condition, "if cell value" > this will only look for cells in this column;
we can not search for any values from other columns.
Currently, we don't have any workaround to achieve that, as well.
-
Let me know if i understood the goal, or if you perhaps need to achieve something else. If you can take screenshots, or make a video to show us in more details;
and i will advise you if it is possible.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Miloš,
Sorry, maybe you are unable to get the page because we work on different netwoks, and communication between both is not allowed to access between one and the other.
I have tried to access in all these ways and I have been able to access without problems.
Respect to conditional format, it looks like the format of a cell depends only on the values of itself, not on the values of another.
I have thought that maybe the solution could be in a hook like this I send you attached.
Although it doesn't work now, take a look and tell me what is your opinion about it.
To clarify, ColID=1 is the column I want to get colored, and ColID=4 is the column with the conditional values "COMPRA" and "VENTA".
Kind regards
Francisco Gutiérrez
Hi Miloš,
I have found a much easier and more elegant solution to the conditional formatting problerm. It consists of a combination between the CASE and CONCAT functions, its form is as follows:
SELECT CONCAT('<a href=/wp.wpdatatable_2 style=color:white>', A.COD_ESTR, '</a>') AS COD_ESTR,
CASE A.TIPO_OP
WHEN 'COMPRA' THEN CONCAT('<wp.wpdatatable_2.td style=color:#009B00>', A.DESCRIPCION_TICKER, '</wp.wpdatatable_2.td>')
WHEN 'VENTA' THEN CONCAT('<wp.wpdatatable_2.td style=color:red>', A.DESCRIPCION_TICKER, ' </wp.wpdatatable_2.td>')
END AS DESCRIPCION_TICKER,
A.MERCADO, A.DESCRIPCION_MERCADO, A.TIPO_OP,
You can see the final result in the attached file.
Kind regards
Francisco Gutiérrez
Hi, Francisco
Thank you for sharing this solution - it looks awesome, both in code and as the displayed result!
I will make sure to share it with colleagues - we will make note of it, it might help for the future.
Thanks once again, and of course - please don't hesitate to reach out if we can assist with anything.
Have a nice day.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Hi Miloš,
It is a pleasure for me to be able to contribute any idea that helps you improve your support.
Kind regards
Francisco Gutiérrez
Hello Francisco,
Thank you for that, once again.
Please let us know if you have any other questions.
Kind Regards,
Uros Jovanovic
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps, and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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