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?
Page 1 / 1
You can use the "Calculated Value" Control and write a formula like this one:
If(contains(Title,"HI"),Title+From,From+Title)
That formula is based on this statement :
IF (Title contains "HI")
Control Value = Title + From
ELSE
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.
Thanks,
Mike
Actually I was using the calculated value in a form like Fernando mentioned above. Thanks for the ideas gentleman!
Hello,
How do you concatenate text with a named control in the formula builder? See attached.
Thank you!
Reply
View our Community Site Map
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.