Adopt Rows Into Model - Invalid Reference ID Error on Insert?

Questions
,
9

I’ve found a workaround for this utilizing a javascript snippet.

The snippet will iterate over rows in a source model and create rows in a destination model. It will also reference a “parent model” for the Id to relate to.

var params = arguments[0],

$ = skuid.$;


//Source Model containing rows we’ll iterate over

var sourceModel = skuid.model.getModel(‘SourceModelName’);

//Destination Model to create new rows in

var destModel = skuid.model.getModel(‘DestModelName’);

//Model containing our parent object that we’ll get the ID from to associate our newly created rows with

var parentModel = skuid.model.getModel(‘ParentModelName’);

var parentRow = parentModel.getFirstRow();

var parentId = parentModel.getFieldValue(parentRow,‘Id’);


//Remove all rows from destModel

destModel.abandonAllRows();


$.each(sourceModel.data,function(i,row){

    var cRow = destModel.createRow({doAppend: true});

    destModel.updateRow(cRow,{

       DestField1__c: sourceModel.getFieldValue(row,‘FieldName’,true),

       DestField2__c: parentId

   });

});