I have a situation that I'm hoping someone has seen before or knows how to fix.
I have an Infopath form with a repeating table that someone fills out country information in each row. I have custom code that determines the user destination based on country by looping through each row of the table. With that, when the person filling out this repeating table submits, an email is sent out to an approver for each country with a link back to the form. Those approvers must then select the row in the table with their country, review the information, select approve, reject, etc, and then submit, all in parallel with the other approvers.
Problem is when one approver opens the form and approves their country, and another does the same at the same time, that first user's approval won't be reflected and appears to be overwritten when the second approves and submits.
Ideally I'd like for only the section of the repeating table with the pertinent country information to be sent to each approver, and then all merged back together once everyone approves, but I'm not sure if this should be done in K2 or Infopath.
Anyone have any suggestions? Is there a better way to do what I'm doing?
Thanks for your help and let me know if I need to clarify more.