How do you concatenate the values of two text fields?

I have a requirement to concatenate the values of two text fields into a new field. For example, Field A has a value of “1000”, and the Field B has a value of “Hallway”. I would like to concatenate those two values into a Field C as “1000 Hallway”. Note the space in between “1000” and “Hallway”. I’m thinking I would have to create a workflow to concatenate upon OnChange. Any suggestions?

If your goal is to have the form refresh immediately when someone modifies either Field A or Field B, an OnChange workflow with a Modify task that has a string formula will solve your issue. Your formula would look like this:

  • Formula Inputs: A = Field A, B = Field B
  • Formula: A + ‘ ‘ + B

You can append static text by adding a string within quotes. This will give your final value with the space you want.

Continue reading


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.