Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

URGENT! How to convert SysID to Value?

Anonym
Kilo Expert

Hey, I auto-populate values of a contract with the details of a related task record by using a business rule and a client script. Most of the populated fields work but some populated display not the Value of the related field but the Sys ID. How can I convert this to a normal value using my BR and CS? 

Some information about the needed code and where to insert would be very helpful.

Thank you for your efforts.

1 ACCEPTED SOLUTION

Brad Bowman
Mega Patron

Reference fields store sys_ids and display whatever the Display column of the reference table is.  If you're not populating this into a field referencing the same table, where you would want to use the sys_id, you can get the display value instead of the sys_id using something like

user = field_name.getDisplayValue();

instead of just

user = field_name. 

If it's still not working for you posting your scripts would be very helpful.

View solution in original post

5 REPLIES 5

Brad Bowman
Mega Patron

Reference fields store sys_ids and display whatever the Display column of the reference table is.  If you're not populating this into a field referencing the same table, where you would want to use the sys_id, you can get the display value instead of the sys_id using something like

user = field_name.getDisplayValue();

instead of just

user = field_name. 

If it's still not working for you posting your scripts would be very helpful.

It works, thank you very much!

Do you have an Idea how I can add line-breaks to a text field by using javascript code?

I have added \n to the contents of a text field, and it translates that when displaying the value into a new line.

Awesome, thank you!

Last Question for today 😉 

Is it possible to make text bold or underline the text in a such a text field?