Auto populate company name from reference field in user table

[dmixer]

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.

[dmixer]

I think I know where you are going with this...

[dmixer]

I changed the field type of u_string_1 from string to reference... still no joy

[Pradeep Sharma]

Is referenced to core_company table. Right?

[dmixer]

Correct,

the u_string_1 field is set to the reference type and references the core_company table...

I did leave the u_string_1 name intact, but I did change it the reference type

[Mike Allen]

It would be ref.company.name in your code.