How to write a function definition with reference fields

[Carter1]

Hi all,

I have a function field that I am trying to concat three separate fields together with "-" in between each. All of these fields are reference fields. I have done it in the past but I can not remember how to write the function so the concat is the display value instead of the sys_id's concat.

Here is my function:

[Carter1 · Accepted solution]

FYI for anyone with the same question:

I figured it out, I was referencing the column names incorrectly when dot-walking..

Ended up being glidefunction:concat(u_cost_center.u_cost_center,"-",u_gl_account.account_name,"-", u_vendor.u_name)

Just make sure you validate the dictionary names, I assumed I had it correct and you know what they say when you assume..