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! Go to 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])>>
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!
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
13 |