I'm designing an application that's supposed to help ease a very tedious and difficult task.
Prior to this app - each user would be given a spreadsheet with about 5-8 columns, and 300-500 rows. (Each user's spreadsheet would be different).
For each and every row, the user would need to populate a value in the last column. That value would be selected from a list of choices (e.g., an Excel drop-down menu) that usually contained 20-30 choices. The list of choices is exactly the same for every row.
The actual context is sensitive, but here's a hypothetical analogous example - the spreadsheet contains a list of bugs for software development project. Each column has a different piece of information about the bug (e.g, the screen on which the bug occurs, the severity of the bug, who discovered the bug, how repeatable it is, etc.) The user must review each bug, and assign the bug to a developer (from a list of about 20 developers). That assignment is made in the last column.
As you can imagine - this is incredibly tedious and time consuming.
By turning this into a web application, I will at least be reducing the time and trouble of distributing the spreadsheets, and ease the process of merging them.
But, I'd also like to be able to create a UI that streamlines the data-entry work as well.
My worst-case solution is a simple table/grid, with a drop-down menu (i.e.
select element) in the last column of every row.
But surely there's a better solution/design pattern for this?