How to show a secondary field if first field is empty

Nicky · July 30, 2024, 12:15pm

Hi Support,

On the attached, I need to replace the @ProjIdInter field under the Description with the @Name field, if the @ProjIdInter field is empty.

I tried modifying the expression in a 2022 post on the forum but it’s not working.

BlazJ · July 30, 2024, 1:00pm

Hi there @Nicky,

The easiest way to achieve to display a different field under a certain condition is to use an iif() function.

The expression in your case should look like this.

iif(@ProjIdInter = '', @Name, @ProjIdInter)

I have modified the template for you as well. You can check the solution there.