Hi Evan, The reason you’re getting the Remoting Exception is that you’re trying to update a Field that does not exist — “Cost” should be “Cost__c”, I believe. As far as getting the Cost__c column in your Table to automatically update whenever Price and Quantity are updated by the user, this is a very good use case for a Custom Field Renderer. Basically, go to your “Cost” column in your table, and change the “Field Renderer” to be “Custom”, then for “Render Snippet”, enter “CostRenderer”. Then, go to your JavaScript Resources, and create a new “Inline (Snippet)” resource, named CostRenderer, with the following Body:
var field = arguments[0], value = arguments[1], $ = skuid.$, dt = field.metadata.displaytype; if (field.mode != 'edit') { skuid.ui.fieldRenderers[dt][field.mode](field,value); } else { skuid.ui.fieldRenderers[dt].edit(field,value); } var calculateCost = function(){ value = (field.model.getFieldValue(field.row,'Quantity__c',true) || 0) * (field.model.getFieldValue(field.row,'Price__c',true) || 0); value = Math.round(value * 100) / 100; field.model.updateRow( field.row, 'Cost__c', value ); if (field.mode == 'edit') { field.element.find('input').val(value); } }; calculateCost(); var listener = new skuid.ui.Field(field.row,field.model,null,{fieldId: 'Cost__c'}); listener.handleChange = function(){ calculateCost(); }; field.model.registerField(listener,'Price__c'); field.model.registerField(listener,'Quantity__c');
The result should be that whenever you change the Price or Quantity fields in your table, your Cost field will be updated.
