My company is looking for a interface for performing Inventory variances. They are currently using a PHP program that lacks a some features they would like to have and are looking for us to migrate to an Appian based platform.
With the current PHP interface, they have a grid where they have the option to select 1 of 3 quantities or to type in a different qty all together. My first thought was an editable grid, but with the number of lines which can exceed 1000. I did start with an editable grid, but after a few lines, the performance slowed down drastically and by the end, was taking up to 1 min per line selection.
I am just looking for some thoughts and ideas on which road to travel down to keep it simple for them to select the qty they want, but also not kill performance.
I have included a snip it of the current PHP interface.
Discussion posts and replies are publicly visible
Why not add paging and filter/sort/search capabilities? That should help with performance.