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

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


Okay wow, that does exactly what I want it to... will follow-up shortly...


NP Daniel.


Please let me know if you are blocked.


Thanks again Pradeep!



From your example, I found my mistake...



When I changed "u_string_1" to a reference field, my code was "ref.company.name" which is wrong and I didn't catch it. When I was looking over your example I tried "g_form.setValue('u_string_1', ref.company);" and it worked perfectly...


Also you can go through the dot-walkin method to pull the field of reference table.


http://wiki.servicenow.com/index.php?title=Dot-Walking