Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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