As we tend to use Excel a lot when working with ServiceNow projects...howto Freeze columns and rows

Freeze columns and rows

Select the cell below the rows and to the right of the columns you want to keep visible when you scroll.
Select View > Freeze Panes > Freeze Panes.

Comments

Get reference display value in CLIENT script

these seem to work! function onSubmit () { alert ( g_form . getDisplayBox ( 'cost_center' ). value ); //--classic UI alert ( g_form . getDisplayValue ( 'cost_center' )); //--service portal }

URL link in addInfoMessage

var ga=new GlideAjax('gld_HR_ajax'); ga.addParam('sysparm_name', 'checkEmployeeNumber_hrProfile'); ga.addParam('sysparm_hrprofilenumber', g_form.getValue('number')); ga.addParam('sysparm_employeenumber', newValue); ga.getXMLAnswer(function(answer) { if (answer!='undefined' && answer!=''){ var navURL="<a style='text-decoration:underline;color:blue' href=hr_profile.do?sysparm_query=number=" + answer + ">" + answer + "</a><img width='3' src='images/s.gif'/>"; var sMsg='The employee number entered already exists on another HR Profile ' + navURL; //alert(sMsg); g_form.showErrorBox('employee_number', 'error - please check'); g_form.addInfoMessage(sMsg); } });

GlideRecord setValue

setValue(String name, Object value) Sets the specified field to the specified value. Normally a script would do a direct assignment, for example, gr.category = value . However, if in a script the element name is a variable, then gr.setValue(elementName, value) can be used. When setting a value, ensure the data type of the field matches the data type of the value you enter. This method cannot be used on journal fields. If the value parameter is null, the record is not updated, and an error is not thrown https://developer.servicenow.com/app.do#!/api_doc?v=madrid&id=r_GlideRecord-setValue_String_Object

ServiceNow Blog

Search This Blog