How to maintain the sequence of records in a related list added inline

I replicated this issue in my Skuid pages and also found that I experienced the same reordering issue when mass importing CSV records into Salesforce. The Salesforce database appears to batch process records in parallel, rather than serially, which means that any mass create action will result in records that appear out of order in an unordered and unsorted table.

I found that sorting by CreatedDate and LastModifiedDate generate the same issue.

• I would suggest ordering by the Line Item Description field name.

• If ordering by Line Item is not helpful, then the next best thing might be to create a new custom field in your Opportunities object that holds a record order number. After you add this field to your Skuid table, you can number the items according to your needs and can set the table to sort by this number. This does mean that you have an extra field to input when creating new records, so it is not an elegant solution.

Josh, Given the limitations i think a custom field holding the order number might be the next best solution. However is there a snippet you can provide that will allow me to auto populate + auto increment that field everytime a new record is created via click of the Create New Row button or during a clone operation.

I tried to implement something…but its not working…Even though it is able to create the sequence numbers. it is not persisting it into salesforce.



var field = arguments[0],
value = arguments[1];
   $ = skuid.$;

if (field.mode == ‘read’) {

 skuid.ui.fieldRenderers.TEXT.read(field,value);
 
}else{

$(document).ready(function() {
    setTimeout(function() {
        var row = field.element[0].parentElement.parentElement.rowIndex;
        skuid.ui.fieldRenderers.TEXT.edit(field,field.element[0].parentElement.parentElement.rowIndex);
    }, 1000);
});
   
}