Is it possible to concatenate two fields conditionally based on the value in another column value provided on a form?
Looks the If statement doesn't include Then Else clause, so instead do you use Form Variables?
You can use the "Calculated Value" Control and write a formula like this one:
That formula is based on this statement :
IF (Title contains "HI")
Control Value = Title + From
Control Value = From + Title
Are you wanting to display the value on your form? If so, using the calculated field as Fernando suggested is good. If you don't need it on the form immediately, then you can do it many ways within the workflow, such as using a Build String action and concatenating values there as well.
Actually I was using the calculated value in a form like Fernando mentioned above. Thanks for the ideas gentleman!
Retrieving data ...