Dynamic change of row color

(0) Share

Report

Posted on by greex

104

Hi. How can I change dynamically color of rows on the list page?

The color depends of global variable. I assigned color (variable) to each record in OnAfterGetRecord trigger - this part works correctly.

After Modify record I need to update color of modified row. I try to do this in OnModifyRecord trigger but it does not work. If I add CurrPage.Update() method - I get memory error on the page in BC.

   field("Quantity"; Rec."Quantity")
  {
    ApplicationArea = Manufacturing;
    StyleExpr = Color;
   }

    trigger OnAfterGetRecord()
    begin
        if Rec."Quantity" < Rec."Total Qty." then
            Color := 'attention'
        else
            Color := 'standard';
    end;
This part does not work:
    trigger OnModifyRecord(): Boolean
    begin
        if Rec."Quantity" < Rec."Total Qty." then
            Color := 'attention'
        else
            Color := 'standard';
    end;

All responses (8)

Answers (1)

Suggested answer

YUN ZHU 85,338 Super User 2025 Season 1 on at

Like (0)

Report

RE: Dynamic change of row color

Hi, just adding some info.

Change field color based on field value in Dynamics 365 Business Central

https://yzhums.com/1599/

Hope this helps as well.

Thanks.

ZHU
Suggested answer

DAnny3211 9,278 Moderator on at

Like (0)

Report

RE: Dynamic change of row color

hi

check my answer if it helped you, thanks

DAniele
greex 104 on at

Like (1)

Report

RE: Dynamic change of row color

It works perfectly! Thank you very much :)!
Verified answer

DAnny3211 9,278 Moderator on at

Like (1)

Report

RE: Dynamic change of row color

CIao

try this

I replicated it on NAV and it works

it seems to me that:

trigger OnModifyRecord(): Boolean
begin
if Rec. "Quantity" < Rec. "Total Qty." then
Colour := 'attention'
else
Colour := 'standard';
end;

is quite useless, it is not needed on the omodify, so change it like this:

trigger OnModifyRecord(): Boolean
begin
CurrPage.UPDATE(FALSE);
end;

then you only need to put it on this trigger:

trigger OnAfterGetRecord()
begin
if Rec. "Quantity" < Rec. "Total Qty." then
Colour := 'attention'
else
Color := 'standard';
end;

check my answer if it helped you, thanks

DAniele
greex 104 on at

Like (0)

Report

RE: Dynamic change of row color

Don't work

Error: Sorry, we just updated this page. Reopen it, and try again.

Page has to close.
Suggested answer

DAnny3211 9,278 Moderator on at

Like (1)

Report

RE: Dynamic change of row color

hello

try putting after your code

cuurPage.update

DAniele
greex 104 on at

Like (0)

Report

RE: Dynamic change of row color

thank you! It works better, but unfortunately still not good enough - if I use OnAfterGetCurrRecord I need to select any other row and again select modified row to update the color. How to do this automatically immediately after update field?
Suggested answer

Nitin Verma 21,567 Moderator on at

Like (1)

Report

RE: Dynamic change of row color

Hi,

Please write your color code in OnafterGetcurrRecord trigger.

Thanks.