Home > Forum > Actions > Coloring Item List Cell when Value change

Coloring Item List Cell when Value change

0

23.03.2021

20:23

Hello all,

Hope you're doing great!

Does anyone configured a rule that will color a cell in a item list upon value change?

I have an item list that will be initialized with values and if the user changes one of them, I want that cell to be marked so it's easier to check the value.

I have found some examples but it's using a rule (like > than X) and it's painting the entire row. In the new release there are new item list actions which allow to paint one cell but I don't know how to write the change value (probably I will have to use SQL command for this).

Any ideas?

Thank you all

Andreia

Sebastian Gębuś

23.03.2021

21:26

MVP

Sebastian Gębuś

Hello,

For more information about coloring rows check this KB article https://community.webcon.com/posts/post/coloring-the-background-of-the-item-list/195/22
In shortcut, for coloring specific cell you need to return column name, and color value in sql statement, something like: SELECT 'DET_Att2', '#eeaaee'.

About tracking changes, it depends on your needs, but simplest solution can be adding technical column which will be storing 'YES' if value was changed or 'NO' if not, or you can write the statement based on list history using WFHistoryElementDetails table.

There is also great article from Kamil Nędza about tracking changes if you want more complex solution - https://alterpaths.com/quick-tip-2-tracking-form-field-change-in-webcon-bps/

Solution (0)

Helpful (1)

Wrong answer (0)

23.03.2021

22:07

Hi Andreia,

I did some testing and the new functions work just fine, you only need to know the appropriate html 'values'.

1) The green border is created by a form rule which is executed on page load. The important thing is to nest the function inside the "for each row" function.
2) The red border / font size is set on value change of the field.

Best regards,
Daniel

Solution (1)

Helpful (1)

Wrong answer (0)