Tabs and List View
I'm trying to set up a database for queuing.
Essentially there is a front desk that will be handling 4 main categories of customer service and I'm trying to create a simple "log in" for people to fill out and the backend will be able to keep track of what requests are out there.
I have attached an image of what I currently have now (for the backend). There is only one table in the database since it is being used for a very simple task.
Ideally I would like to have the backend use a tabbed approach based on the 4 categories combined with a scrollable view within each tab that only shows data that have the same "category/help needed with" field. I am hoping to show multiple records within each tab so it can provide a more accurate view of what is going on.
Then I would like it to sort the data within each category by a "first come first serve" basis. Once the "task accepted" box has been checked it would send that record to the bottom. I have figured out the sorting part just not within a specific tab.
Is there a way to do this?