How to make record producer automatically populate field when user load the request form in service portal?

Betty9
Tera Contributor

I have a record producer variable 'company' which mapping to incident table 'company' , I want to make this variable automatically populate 'company' variable when user load the request form in service portal. How to do it?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

based on logged in user?

if yes then you can use default value in that variable; I assume that variable is of type reference

javascript: gs.getUser().getCompanyID();

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

18 REPLIES 18

yes, the record producer variable is also reference field and referring to 'Company' table 

Write an OnLoad client script as below

function onLoad() {
  
	var now_GR = new GlideRecord('sys_user'); 
    now_GR.addQuery('sys_id', g_user.userID); 
	now_GR.query(response); 

function response(result) {
    if (result.next()) {
	g_form.setValue('company', result.getValue('company'));
    }
}
	
   
}

 

Mark as correct and helpful if it solved your query.

Regards,
Sumanth

SumanthDosapati
Mega Sage
Mega Sage

Hi Betty,

Write an OnLoad client script as below

function onLoad() {
  
	var now_GR = new GlideRecord('sys_user'); 
    now_GR.addQuery('sys_id', g_user.userID); 
	now_GR.query(response); 

function response(result) {
    if (result.next()) {
	g_form.setValue('company', result.getValue('company'));
    }
}
	
   
}

 

Mark as correct and helpful if it solved your query.

Regards,
Sumanth

Hi Betty,

Did you try above solution?

 

Feel free to reach out if you have further questions or else you can mark an answer as correct and helpful to close the thread so that it benefits future visitors also.

Regards,
Sumanth