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;

I have the same question (1)

All responses (8)

Answers (1)

Suggested answer

Nitin Verma 21,698 Moderator on at

Like (1)

Report

Hi,

Please write your color code in OnafterGetcurrRecord trigger.

Thanks.

Was this reply helpful? Yes No
greex 104 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (1)

Report

hello

try putting after your code

cuurPage.update

DAniele

Was this reply helpful? Yes No
greex 104 on at

Like (0)

Report

Don't work

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

Page has to close.

Was this reply helpful? Yes No
Verified answer

DAnny3211 11,397 on at

Like (1)

Report

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

Was this reply helpful? Yes No
greex 104 on at

Like (1)

Report

It works perfectly! Thank you very much :)!

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,397 on at

Like (0)

Report

hi

check my answer if it helped you, thanks

DAniele

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No