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,047

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?

All responses (6)

Answers (0)

Suggested answer

YUN ZHU 82,109 Super User 2025 Season 1 on at

Like (1)

Report

RE: need to change font color based on some condition

Hi, hope the following helps.

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

https://yzhums.com/1599/

Thanks.

ZHU
Suggested answer

pankaj.k 974 on at

Like (2)

Report

RE: need to change font color based on some condition

Hi Inkey

Check with my answer

New Field Value must be Standard or Unfavorable.
Inkey Solutions 2,047 on at

Like (0)

Report

RE: need to change font color based on some condition

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.
Suggested answer

DAnny3211 9,276 Moderator on at

Like (0)

Report

RE: need to change font color based on some condition

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
Suggested answer

pankaj.k 974 on at

Like (0)

Report

RE: need to change font color based on some condition

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.
Suggested answer

Nitin Verma 21,544 Moderator on at

Like (0)

Report

RE: need to change font color based on some condition

Hi,

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

put your code on OnAfterGetCurrRecord too.

Thanks.