I currently have two models, Model A and B. I want the values from Model saved to one field on Model B.
I coded a button to pass condition values to Model A. Model A will have 3 different lines and different data in Field__c. I need to concatenate the values in Field__c on Model A and update one field on Model B.
Does anyone know how I could achieve this?
Page 1 / 1
So assuming that there is only one row in Model B that you want to store the field values from all rows in Model A into, this snippet should work:
var modelA = skuid.$M("ModelA");
var modelB = skuid.$M("ModelB");
var sourceField = "Field__c";
var targetField = "Target_Field__c";
// assuming you want to comma-separate the values, change this to something else if needed
var separator = ",";
modelB.updateRow(
modelB.getFirstRow(),
targetField,
modelA.getRows().map(function(row) {
return modelA.getFieldValue(row, sourceField, true);
}).join(separator)
);```
Thank you Zach this is great! I also found that if I use (JOIN_TEXT) as a formula within the action to update row works as well.
OHHH — using JOIN_TEXT is a great idea, love it.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.