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.
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.
@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.
How aboutโฆ <<IFS(ISNOTBLANK([Product].[Description]),CONCATENATE("Description: ",[Product].[Description]))>>
User | Count |
---|---|
44 | |
35 | |
25 | |
24 | |
15 |