Auto populate company name from reference field in user table

dmixer
Mega Contributor

Hello all,

I have a bit of an issue I've been poking around with for more than I would care to admit. I've been working on auto populating various string fields, which thanks to the Snow community I'm enjoying some success.

The script I am using is as follows:

function onChange(control, oldValue, newValue, isLoading) {

  var ref = g_form.getReference('u_reference_4', setUser);

}

function setUser(ref) {

  if (ref)

  g_form.setValue('u_string_5', ref.u_end_user_name);

  g_form.setValue('u_string_3', ref.u_rptc_income_st);

g_form.setValue('u_string_1', ref.company); // does not display value, only sys_id

}

Basically, when 'u_reference_4' is set to its value, u_string_5 and u_string_3 auto populate. - this works great...

My issue is, I need to auto populate one more field, u_string_1 from a value in a reference field from my user form that references the core_company table. When I script it in to the above, I either get a "undefined" error or the actual sys_id. I need the end users company name to also auto populate based on the employee ID set in u_reference_4.

Any assistance would be greatly appreciated.

1 ACCEPTED SOLUTION

Hi Daniel,



You can refer the below demo where I have created an example.


https://demo006.service-now.com/login.do


Username : admin


Password : admin


Client script : (BP) Set Location to User


View solution in original post

19 REPLIES 19

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

Hi Daniel,



Make sure the field u_string_1 is a reference field to core_company table.


Not sure I follow...



u_string_1 is a field within a new application in Snow. On my user form is a Company reference field with a company name value that I need to auto populate to u_string_1.


Hi Daniel,



What is the type of field u_string_1. Please confirm


The company field is a String type