Update Requester based on new field EmployeeID
I am trying to write a script to update the requester field on the incident template when a technician types in the employee id into a field i created. The part I am stuck on is how to "lookup" the requester by the number entered as a field and form rule on field update.
so in this pseudo code example...
var x=$CS.getValue("EMPID");
var y=lookup requester(x) return name
$CS.setValue("REQUESTER",y);
Is this possible?
If not in field and form rule, can a script work? I am trying to avoid that though.
Thanks.
so in this pseudo code example...
var x=$CS.getValue("EMPID");
var y=lookup requester(x) return name
$CS.setValue("REQUESTER",y);
Is this possible?
If not in field and form rule, can a script work? I am trying to avoid that though.
Thanks.