How can I Concat UDF's and get the Description instead

Hi ​@CameronSchultz , if you are pulling attributes from the screen they live directly, you will only see the value ID of the attribute. Since the attributes actually live on the CSAnswers DAC, assuming you are creating a generic inquiry here, you will need to join SOOrder to CSAnswers on that sepcific attribute field. And then you will have the option to show the descriptions on the GI for this attribute. I hope this helps! 

​@jzhu After trying this I cant seem to get that data to show up on the GI. Is this not the correct relationship setup? I have created one join so far for one of the UDFs. I am joining that into SOOrder and using noteID and RefNoteIT as the relation. Do I need to go all the way to AttributeDetail to get the data?

HI ​@CameronSchultz I just tested it too but for some reason attributes on SOOrder didn’t behave the same as I thought it would for attributes on InventoryItem. This is what I was thinking when I made the initial suggestion, where AttributeCOLORWAY is just my alias for CSAnswer. 

So since this didn’t work with SOOrder for some reason, I went ahead and tried your formula on two attributes I have on SO, they worked great with pulling the value description instead of value ID. NEWATTRIB is a text field, and NEW2 is a combo with drop down. Both are showing the description instead of the ID. Is this what you are looking for? 

​@jzhu 

It looks like it is also doing the same thing for you. When using Concat your “two” value is showing up as 2 from the value ID and not the desc. That is the same thing I am dealing with. I need it to come across as “two” even when using Concat. So perhaps its an issue with Combo UDFs in particular