Can you concatenate single line text fields? | Community
Skip to main content
Level 2
June 16, 2021
Solved

Can you concatenate single line text fields?

  • June 16, 2021
  • 2 replies
  • 1935 views

I have multiple project forms associated with one project, and each form has a unique single line text field that I'd like to concatenate in one spot. I did this with the other fields that have radio buttons or checkboxes, making reporting much easier. Is this possible with text fields?!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by skyehansen

I would try a couple of things right off the bat. First I would try this:

CONCAT({"Other" Communication Topic}, {#2 "Other" Communication Topic}, {#3 "Other" Communication Topic}, {#4 "Other" Communication Topic}, {#5 "Other" Communication Topic})

If that doesn't work, I would rename your fields and try again with new field names. I recommend not putting any special characters like quote marks and hashes in field names. If you wanted to leave those in your field labels for your users to see, that's up to you, but they don't need to live in field names and so they shouldn't. Same goes for question marks, slashes, and ... well, any punctuation really.

2 replies

RandyRoberts
Community Advisor
Community Advisor
June 16, 2021

Short answer, sure!

Level 2
June 16, 2021

Great, but what is the long answer? Lol. I need a calculation that works, my attempts haven't yet been successful.

skyehansen
Community Advisor
skyehansenCommunity AdvisorAccepted solution
June 17, 2021

I would try a couple of things right off the bat. First I would try this:

CONCAT({"Other" Communication Topic}, {#2 "Other" Communication Topic}, {#3 "Other" Communication Topic}, {#4 "Other" Communication Topic}, {#5 "Other" Communication Topic})

If that doesn't work, I would rename your fields and try again with new field names. I recommend not putting any special characters like quote marks and hashes in field names. If you wanted to leave those in your field labels for your users to see, that's up to you, but they don't need to live in field names and so they shouldn't. Same goes for question marks, slashes, and ... well, any punctuation really.