Create a new record on a different table, pre-populate reference field?

[Robert_Cartwrig]

Hi all,

I'm kinda stuck on something and am looking for a little advice.   I'm getting that I might be stuck needing to run both server and client script in the same UI Action and that I may not be taking the proper steps to make this work.

The Use Case: A Tier 1 Agent is looking at a Consumer Record and needs to Create a New Case from a UI Action.   The new Case needs to be populated with a number of pieces of data from the Consumer record.   How do I make this happen?

The Issue:

• The OOB (with CSM)   "Create a New Case" UI action will create a new Case and populate the Consumer field - but using this, the normal option I use for passing data on UI Actions ("ccc.newfield = current.oldfield", and "setValue("fieldX", '42')") don't work when added to the OOB script.
• If I use custom code I've used in other situations to create a record and pass/set values, I can't seem to populate the Consumer and Company fields on the Case - but maybe I'm just passing the wrong data (email and a sys_is, respectively). I know I can type in an email address to the Consumer field and it resolves to a Consumer but this does not seem to happen from a UI Action, but passing Name doesn't work either - so I don't know what else to pass.   Same issue with Company, only I'm passing a sys_ID.

The Examples:

Here is an example of the OOB code that Creates a new Case and pre-populates Consumer:

var query = '/sn_customerservice_case.do?sys_id=-1&sysparm_view=case&sysparm_query=';
var subQuery = '';
if(!gs.nil(current.getValue("sys_id"))){
       if(query.length > 0)
               subQuery+='^consumer='+current.getValue("sys_id");
       else
               subQuery+='consumer='+current.getValue("sys_id");
}
action.setRedirectURL(query+subQuery);   

Here is an example of the code I would typically use in this situation:

createCase();
function createCase(){
var cs = new GlideRecord("sn_customerservice_case");
       cs.setValue("priority", '4');
       cs.setValue("u_corp_or_product", '2');
       cs.setValue("assignment_group",'f67899164fe66600ccee42fd0210c78e');
       cs.setValue("contact_type",'phone');
       cs.setValue("state",'10');
       cs.u_participant_id = current.u_participant_id;
       cs.u_incontact_id = current.u_incontact_id;
       cs.assigned_to = gs.getUserID();
       cs.consumer = current.email; //DOES NOT WORK
       cs.company = current.u_company_affiliation; //DOES NOT WORK
var sysID = cs.insert();
current.sn_customerservice_case_id = sysID;
var mySysID = current.update();
action.setRedirectURL(cs);
action.setReturnURL(current);
} 

Lines 13 and 14 above are what I cannot seem to make happen.   I've verified both are passing data by passing to a string field.

Any advice or suggestions here would be greatly appreciated.

Thank you,

Robert

[sb1186]

Hi Robert,

Glad I could help

Regards

Supriya Bisht