Workflow and Report Templates 1 field 2 different responses

[Work_Goscinski]

From my data set, a True/False question is asked of an inspector.

Is there a way in an email template to have True appear in one box, but if it was marked False in another box?

I want the left box to display my True Value and the right box my False value.

Thanks.

[Steve · Accepted solution]

help.appsheet.com

Template If Expressions

Using If expressions in your workflow templates.

[Work_Goscinski]

That is very helpful, but I can’t seem to get this expression to work right.

<<If: [Proper Label?]=Unsatisfactory <<[Proper Label?]>> <>

I have tried “Unsatisfactory” and Unsatisfactory.

The log returns: Expression ‘[Proper Label?]=Unsatisfactory <<[Proper Label?]’ is invalid due to: Arithmetic expression ‘(([Proper Label?] = “Unsatisfactory”) < [Proper Label?])’ does not have valid input types.

I am not sure what that means.

[Steve]

What is the column type of the Proper Label? column?

[Work_Goscinski]

Text

[Steve]

A’ight, so the problem isn’t a data type mismatch. On to the next problem: your <<If>> tag is improperly constructed. This:

<<If: [Proper Label?]=Unsatisfactory <<[Proper Label?]>> <<EndIf>>

should be:

<<If: [Proper Label?]=Unsatisfactory>><<[Proper Label?]>> <<EndIf>>

You didn’t close the <<If>> tag.

[Work_Goscinski]

I understand what you are saying. I did forget to close it. Good catch.

<<If: [Proper Label?]=Unsatisfactory>> <<[Proper Label?]>> <>

results in:

Expression ‘[Proper Label?]=Unsatisfactory <<[Proper Label?]’ is invalid due to: Arithmetic expression ‘(([Proper Label?] = “Unsatisfactory”) < [Proper Label?])’ does not have valid input types. Error: Report ‘Dock Audit Record’ action ‘Action 1’ Attachment template. ‘If’ expression ‘[Proper Label?]=Unsatisfactory <<[Proper Label?]’ yields a result of type ‘’ rather than the expected type ‘Yes/No’.",

[Work_Goscinski]

Ignore that. I copied the wrong log.

Works great!

Thanks for your help.