Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Combining field values into a "super field".

Avatar

Level 2

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?

1 Reply

Avatar

Community Advisor

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