URGENT! How to convert SysID to Value?

Go to solution
Anonym
Kilo Expert

‎03-16-2021 04:00 AM

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.

Labels:
0 Helpfuls
  • 2,204 Views
1 ACCEPTED SOLUTION

Go to solution
Brad Bowman
Kilo Patron
Kilo Patron

‎03-16-2021 04:26 AM

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

Go to solution
Brad Bowman
Kilo Patron
Kilo Patron
In response to Anonym

‎03-16-2021 06:20 AM

Not if the field type is String.  This is possible on the field type HTML, by adding the <strong> or <b> opening and </strong> or </b> closing tags for bold.  For underline on this field type you would need to add <span style="text-decoration: underline;">text to be underlined</span>. 

Please close this thread by marking one answer Correct, and also any responses that you found Helpful.