Email fields show N and Y instead of No and Yes

I have a report that is emailed out to a lot of people and there are several Yes/No fields. On the form it shows Yes and No but on the email it shows Y or N. Here is a pic

Tragertt_0-1683844975733.png

Is there any way to have it show "Yes" or "No" instead of "Y" or "N"?

0 3 146
3 REPLIES 3

What does that have to do with the email showing "yes" instead of just a "y"?

Maybe nothing--sorry. It might be possible to use template If expressions to accomplish what you want, but I should have pointed you to template expression variables. You could use an IF function in an expression to return the display value that corresponds for each banked value.

Top Labels in this Space