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

(Megumi Oka) #1

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) #2

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) #3

@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) #4

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