I have been experimenting with msg.ui_control to construct a table of profit and loses. I have been able to do addition of individual columns but now I want to calculate net profit/loss which involves dividing the sum of one column with another, which i am not able to accomplish. [image] In this i…

Sorry for the delay (I had a busy week) You will need a callback function as described in the docs. Your function will look like this: var totalPercentage = function(values, data, calcParams){ var sumOfTotalInvested = 0; var sumOfTotalProfit = 0; data.forEach((row) => { sumOfTo…

Hi. I think you have to write your own calculation function. As you have access to the complete table data it should be doable. [image] Tabulator - Interactive JavaScript Tables Create interactive data tables in seconds with Tabulator. A lightweight, fully featured JavaScript table gen…

Yes I have seen that but I am not able to get it working. Any pointer towards that would be helpful

Perhaps you can post the relevant part of your flow to make it easier to give you the right starting point

I am experimenting with custom calculation functions, will update soon, In the meantime how can I change the background color of a cell in accordance to the value? I want to change the color of a cell to red if the numeric value is negative and green if positive.

Hi, you can an example how to change the background (or any other css attribute) here: Ui-table row change background color on updateorAddData - #4 by dceejay Another good starting point how to work with ui_control is the exampe 6: [image]

How can I set the property of each column and sub column using msg.ui_control?

Simple By sending ui_control.tabulator messages. I can‘t see or experienced any limitations.

And these messages accumulate. So you can keep your basic configuration (in the config dialog) and add additional parameters to them. For the column array: When the property = field parameter matches it will be added to a specific column. See example 6

Basically my expertise is in mechanical engineering, thats why I am creating whole sort of such problems. Here in this case I am passing this ui_control msg { "tabulator": { "minHeight": 600, "autoColumns": true, "columnHeaderVertAlign": "middle", "hozAlign": "ce…

If there are sub columns under a column, how will the property be defined?, I mean if I am not specifically mentioning the property payload in the msg.ui_control

Node-RED

Node-RED Forum

UI table percentage Calculation

Dashboard

system Closed 25 September 2021 16:36 17

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Add value in overprint in a column of Ui_Table with the format "Progress (0-100) Dashboard	9	530	4 June 2022
Ui-table in conjunction with ui-table handler General	10	2742	21 March 2022
Set background color of row ui table for different data Dashboard	10	1429	13 November 2022
UI Table Adjustments Dashboard	15	3615	21 January 2022
The colorization of ui_table is kicking me in the head! General	20	3723	15 September 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

UI table percentage Calculation

Related topics