Can you concatenate single line text fields? | Community
Skip to main content
T
Toneia_Lane
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
    RandyRobertsCommunity Advisor
    Community Advisor
    June 16, 2021

    Short answer, sure!

    T
    Toneia_LaneAuthor
    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.

    T
    Toneia_LaneAuthor
    Level 2
    June 17, 2021

    Hi Skye,

    I'd be happy to have a solution for a calculated field in a custom form or a report, although I've been trying it on a custom form since that's what I've done for the others, and it gives me one simple field to pull in to my reports. This is how I have the calculated field on my custom form formatted for my concatenated radio dial/checkbox fields;

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

    It doesn't seem to be yielding me the text from my text field(s).

    Terms & ConditionsAccessibility statement

    Loading footer...