Is there a formula that you can include in yo...

[Megumi_Oka]

Is there a formula that you can include in your email template to hide columns that are blank when sending an email notification? For example, in the ClickToSendEmail example app, you can email the product. If the description of the product was blank, then the formula would automatically exclude the Description from the email.

[Aleksi_Alkio]

May I ask this… why do you need to hide that value if it’s blank? The app doesn’t show that field’s value automatically if it’s blank.

[Megumi_Oka]

@Aleksi_Alkio What we have in our email looks like this:

Description: <<[Product].[Description]>>

We’d want to enclose that entire line in a formula so that the text “Description:” would be hidden if <<[Product].[Description]>> is blank.

[Aleksi_Alkio]

How about… <<IFS(ISNOTBLANK([Product].[Description]),CONCATENATE("Description: ",[Product].[Description]))>>