Combining field values into a "super field". | Community
Skip to main content
S
ShaneLa1
Level 2
April 13, 2020
Question

Combining field values into a "super field".

  • April 13, 2020
  • 1 reply
  • 360 views

We have a number of custom form fields that we use to "bucketize" our work. It is helpful they are separated for conditional logic and user experience. For some of our more advanced reporting we are running into needing a number of field values to be combined into a "super field". We are able to do this with out data team as a transformation outside of the system but wondering if we can use a calculated field with if/then statements or something else to accomplish this natively. Anyone had success doing this? Any other ideas?

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

    1 reply

    Heather_Kulbacki
    Community Advisor
    Heather_KulbackiCommunity Advisor
    Community Advisor
    April 14, 2020

    If you just need to combine multiple fields into a single column on a report, CONCAT works well

    https://one.workfront.com/s/article/Calculated-data-expressions-679086747

    I also seem to wind up using IF/THEN statements frequently - and sometimes combining those with CONCAT

    Terms & ConditionsAccessibility statement

    Loading footer...