Editable Grid - Need a solution to update sort id's

Question

Hi Everyone , 
 Need your help in solving below problem . 
 I have a requirement where i can insert data in between any rows but Type will always be Manager . When i add new row, i need to generate a new id and want to update/increment sort id's of all the rows which has Type as Manager accordingly.

For example - I added a row after id = 3 or at 4th place so my new row will have id = 6 , Type = Manager and sort id = 2 . Also, sort id for last row which has Type='Manager' gets updated with 3 .

Thanks in advance

vimalkumars · Answer

Your code looks good. Just replace your hard-coded value "Manager" with ri!employees[fv!index].type 
 a!imageField(
 label: "Add " & ri!index,
 images: a!documentImage(
 document: a!iconIndicator("ADD"),
 altText: "Add Employee",
 caption: "Add Employee Here",
 link: a!dynamicLink(
 label: "Add Employee",
 value: 'type!{urn:com:appian:types:Employee}AS_Employee'(
 employeeTag: tostring(1),
 type: ri!employees[fv!index].type,
 activeFlag: true,
 createdBy: loggedInUser(),
 createdDt: now(),
 modifiedBy: loggedInUser(),
 modifiedDt: now(),
 sortId: if(
 rule!APN_isEmpty(ri!employees[ri!index].sortId),
 {},
 sum(ri!employees[ri!index].sortId, 1)
 )
 ),
 saveInto: {
 a!save(
 ri!employees,
 insert(ri!employees, save!value, ri!index + 1)
 ),
 a!save(
 ri!employees,
 a!forEach(
 items: ri!employees,
 expression: updatedictionary(
 dictionary: fv!item,
 fieldsAndValues: if(
 and(
 fv!item.type = ri!employees[fv!index].type,
 fv!index > ri!index + 1
 ),
 {
 sortId: if(
 rule!APN_isEmpty(fv!item.sortId),
 "",
 sum(fv!item.sortId, 1)
 )
 },
 {}
 )
 )
 )
 )
 }
 )
 )
),

vimalkumars · Answer

Understood. This one should help. 
 a!imageField(
 label: "Add " & ri!index,
 images: a!documentImage(
 document: a!iconIndicator("ADD"),
 altText: "Add Employee",
 caption: "Add Employee Here",
 link: a!dynamicLink(
 label: "Add Employee",
 value: a!map(
 id: length(ri!employees) + 1,
 employeeTag: tostring(1),
 type: "Manager",
 activeFlag: true,
 createdBy: loggedInUser(),
 createdDt: now(),
 modifiedBy: loggedInUser(),
 modifiedDt: now(),
 sortId: if(
 rule!ALOG_isNullOrEmpty(ri!employees[ri!index].sortId),
 {},
 sum(ri!employees[ri!index].sortId, 1)
 )
 ),
 saveInto: {
 a!save(
 ri!employees,
 insert(ri!employees, save!value, ri!index + 1)
 ),
 a!save(
 ri!employees.sortId,
 a!localVariables(
 local!managerIndices: wherecontains("Manager", ri!employees.type),
 updatearray(
 ri!employees.sortId,
 local!managerIndices,
 enumerate(count(local!managerIndices)) + 1
 )
 )
 )
 }
 )
 )
 )

Editable Grid - Need a solution to update sort id's

Top Replies