topic Re: Font color in App Development

Font color

nvijay5757 — Tue, 29 Nov 2022 04:12:56 GMT

Hi,

i am trying font color.

my expression is :

=If(( (Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11))>=1),'KD'&
Pick(Match(Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11),'1','2','3','4','5','6'),chr(185),chr(178),chr(179),chr(8308),chr(8309),chr(8310)),
If(( (Count({<KD_new={'nKD'},Modes11={'8RB'}>} DISTINCT Modes11))>=1),'nKD'))&''&

If(( (Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11))>=1),', KD'&
Pick(Match(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11),'1','2','3','4','5','6'),chr(185),chr(178),chr(179),chr(8308),chr(8309),chr(8310)),
If(( (Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Modes11))>=1),', nKD'))

output is KD, nKD. here font color is if KD blue color, if nKD black color.

i have tried.

IF(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Test)>=1 and Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Test)=0,RGB(0,0,240),Black()) for one is working how will give both KD, nKD.

Thanks

Re: Font color

vinieme12 — Tue, 29 Nov 2022 03:30:23 GMT

IF(Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Test)>=1 and Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Test)=0,RGB(0,0,240),Black()) for one is working how will give both 8RB,8UNC.

can you elaborate maybe with screenshots what are you trying to do here?

Re: Font color

nvijay5757 — Tue, 29 Nov 2022 04:27:12 GMT

Hi Vineeth,

above expression updated.

in text object or in table we are showing KD, nKD.

if condition is true then KD. else nKD.

like if condition is true then blue color else black color.

ex: below screen shot KD-blue color, nKD - black color

Re: Font color

vinieme12 — Tue, 29 Nov 2022 06:27:49 GMT

try below

=If( (Count({<KD_new={'KD'},Modes11={'8RB'}>} DISTINCT Modes11)>=1) or (Count({<KD_new={'KD'},Modes11={'8UNC'}>} DISTINCT Modes11)>=1) ,RGB(0,0,240)

,if( (Count({<KD_new={'nKD'},Modes11={'8RB'}>} DISTINCT Modes11)>=1) or (Count({<KD_new={'nKD'},Modes11={'8UNC'}>} DISTINCT Modes11)>=1) ,black()
)

Re: Font color

nvijay5757 — Tue, 29 Nov 2022 06:56:15 GMT

Hi,

i am getting same color for both values.

Re: Font color

vinieme12 — Tue, 29 Nov 2022 07:01:56 GMT

if you are referring to the column 8RB ; i can confirm one cell can only have one font color

Re: Font color

nvijay5757 — Tue, 29 Nov 2022 09:51:44 GMT

Ok. in text object also same.