Workflow and Report Templates 1 field 2 different responses

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?

image

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

Thanks.

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.

1 Like

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

Text

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.

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’.",

1 Like

Ignore that. I copied the wrong log.

Works great!

Thanks for your help.

1 Like