Business Rule to populate the Field values From Another Field Through Reference Field

[sekhar6]

Hai,

Need a help in creating business rule. I am new to service now .kindly help on this script.

I Have an Customer Field On the form ,I have taken Reference table in Customer Field, If I Select The Customer Field, Display the Customer Name field and Multiplier Field  

 I Was Trying This Script ,Using Business Rule.

var gt = new GlideRecord('u_ln_customers');
gt.addQuery('u_ln_customers', current.u_customer);
gt.query();

if('u_customerISNOTEMPTY');
{}

if(gt.next()){}

current.u_ln_customers_u_customer_name =gt.u_customer.u_cname;

current.u_ln_customers_u_multiplier = gt.u_customer.u_multiplier;

 

[Ankur Bawiskar]

Hi,

try this since u_customer is already reference then no need to query

Directly dot walk and fetch the values

current.u_ln_customers_u_customer_name = current.u_customer.u_cname;
current.u_ln_customers_u_multiplier = current.u_customer.u_multiplier;

Regards
Ankur

[sekhar6]

Hai 

Ankur Bawiskar,

Its Not Work ,Please help me on this,

Thank you.

[Ankur Bawiskar]

Hi,

please share some more details

1) u_customer field is referring to which table

2) which table is having u_customer field? is it Special event?

Regards
Ankur

[sekhar6]

Hai,

we have Taken reference tables as"  u_ln_customers  "

[Ankur Bawiskar]

update as this

current.u_customer_name = current.u_customer.u_cname;
current.u_multiplier = current.u_customer.u_multiplier;

Regards
Ankur