Combining field values into a "super field".

Question

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?

Heather_Kulbacki · Answer

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

Faça o registo

Fazer o login com rede social

Bem-vindo

Fazer o login com rede social