I am looking at using AppSheet to manage project tasks. There are many good sample apps to base this on. So I have a good basis to start from.
I have two challenges, both related to sorting the project task list:
- I want users to be able to add a new task and then choose where in the project task list it goes.
- Similar to above, for existing tasks I want a user to be able to “move” the task to another place in the project task list.
I can achieve a crude version of this by having a “Order” column that the project task list is sorted on. The user can manually update the number. However, it becomes unusable very quickly with multiple numbers the same or it becomes very complex if I allow decimals in the sort column.
I am hopeful there is quick and easy solution to this.