Small and medium business | Business Central, N...

need to change font color based on some condition

(0) Share

Report

Posted on by Inkey Solutions

2,102

Hi,

I need to highlight the general journal lines field[shortcut dimension 1 code] based on some filter and I tried to write code for that but it didn't work as expected.

you can see in the below screen print I tried this two-way, one is to create a custom action and write the logic in that, and the second is using the standard trigger of Microsoft.

Note: here GetCorporateId() is my custom procedure and it is working as expected.

This above code didn't work as expected, it has been populated with red color in all the lines, But what I need is when the Corporate id is 14 then I need to highlight the 'shortcut dimension 1 field' with red color otherwise none.

Can anyone tell us what is the missing part in this code?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Nitin Verma 21,788 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please always put your code in text format not in image.

put your code on OnAfterGetCurrRecord too.

Thanks.

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,018 on at

Like (0)

Report
Copy link

Link copied!

Hi Inkey,

everything is fine but you need to do some more customization for this Please check below steps.

Step1: Create one new Text filed For Storing the data Standard or Unfavorable.

Step2: Assign StyleEXpr to your NewField. (StyleExpr = NewField;)

Add my suggestion with your customization that will work.

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,407 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

CIao

use the second and enter onmodify on the page

CurrPage.UPDATE(FALSE);

if that doesn't work, check the getcorporateid function again, I don't want there to be anything wrong with it

DAniele

Was this reply helpful? Yes No
Inkey Solutions 2,102 on at

Like (0)

Report
Copy link

Link copied!

Hi Daniele Incalza,

Your answer is works for me but when I try to insert new other lines it will give me the below error.

Thank you.

Was this reply helpful? Yes No
Suggested answer

pankaj.k 1,018 on at

Like (2)

Report
Copy link

Link copied!

Hi Inkey

Check with my answer

New Field Value must be Standard or Unfavorable.

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 98,240 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi, hope the following helps.

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

https://yzhums.com/1599/

Thanks.

ZHU

Was this reply helpful? Yes No