Show field in email custom template if field has data

I am trying to figure out how to tell my email template to show a field if it is not blank.  This is my current email template and the If statement is what I am trying to use...any help is appreciated (P.S.  This is currently not working)

 

A CAR is waiting for your approval:

If(isnotblank(<<[ResubmitComments]>>),"This CAR has been resubmitted: " <<[ResubmitComments]>>,"")

Current Status: <<CARStatus>>
Facility: <<[FacilityName]>>
Project Title: <<[vcProjectTitle]>>
CAR Amount: <<[CAR Amount]>>
Budget Type: <<[BudgetType]>>
Category: <<[Category]>>

Click <a href='<<CONCATENATE('https://www.appsheet.com/start/426526ce-121f-46af-a207-1cb4b129a492#view=EditCAR&row=',[ProjectID])>>'><b><u>HERE</u></b></a> to view the record.

Solved Solved
0 2 67
1 ACCEPTED SOLUTION

In a template, be sure you wrap any AppSheet expression within the "angle quote" identifiers.

<<If(isnotblank([ResubmitComments]),"This CAR has been resubmitted: " & [ResubmitComments],"")>>

or, alternatively, just:

<<IfS(isnotblank([ResubmitComments]),"This CAR has been resubmitted: " & [ResubmitComments])>>

View solution in original post

2 REPLIES 2

In a template, be sure you wrap any AppSheet expression within the "angle quote" identifiers.

<<If(isnotblank([ResubmitComments]),"This CAR has been resubmitted: " & [ResubmitComments],"")>>

or, alternatively, just:

<<IfS(isnotblank([ResubmitComments]),"This CAR has been resubmitted: " & [ResubmitComments])>>

Thanks so much...that did the trick!

Top Labels in this Space