Display boolean Y/N as label on a template with expression

AppSheet AppSheet Q&A
, ,
1

Currently my column <<[Status]>> type boolean has two labels “Inactivo” and “Activo” but in the PDF report the value displayed as Y or N.

Should I make another table to deference a label column for this boolean or there’s way to display the label in the report directly from the preconfigured column?

2

No, you can’t access the custom display values via expression. You’ll need to enter them into the template manually with an IFS or SWITCH, or like you said, set up another Table to deref from.

4 Likes