topic Colors to Null symbol '-' in App Development

Colors to Null symbol '-'

Sra1bandi — Sun, 23 Oct 2022 16:21:48 GMT

Hi Team,

In normal Table Need to fill colors in the cell '-',.

i am using expression :- If(not IsNull([Your Field]), [Your Field], ' ')

with above function i am getting colors in empty cell but i am not getting color with the symbol in the cell '-'

How to fill colors for the values '-' in the table?

Regards,

Sra1.

Re: Colors to Null symbol '-'

ckarras22 — Sun, 23 Oct 2022 17:35:09 GMT

If the NULLs come from the load script, then you can use the NullAsValue and NullValue like below

NullAsValue Phone; Set NullValue = '-'; LOAD CustomerID, Name_CStmr, Phone FROM [lib://ssdd/Customer - nulls.xlsx] (ooxml, embedded labels, table is Customer);

then you can use it as usual in the table

If the NULLs are generated on the fly, the "Background color expression" has no effect. The check happens before the NULL generation

Re: Colors to Null symbol '-'

Sra1bandi — Mon, 24 Oct 2022 04:12:43 GMT

Hi Ckarras,

Thanks for your reply.

I am used that also still it's not getting.