Priority/Order of employee task list

[jeffchoy]

I am creating an app where I want to specify a number of tasks for employees to complete each day in a retail store. I want to be able to enter a task at a time and have the priority or order to increment by one each time I enter a new task. So task priority/order [TASKID] 1 needs to be completed first and then TASKID 2 then 3 and so on …

Each time I create a new task, I count the number of tasks already there for that date and then increment by one which works fine.

COUNT(FILTER(“TASKS”, ([DATE] = [_THISROW].[DATE]))) + 1

Problem is if I delete a task, say TASKID 3 then the task in the list is TASKID 1, 2, 4. I would really like to have the TASKID list order to be changed to TAKID 1, 2, 3.

Also, currently if I add a new task it just counts how many tasks there currently is and increments by 1. So in the example above if I have TASKID 1, 2, 4 and then I add another task I will have TASKID 1, 2, 4, 4.

Can anyone suggest what expression I could use so that the TASKID list shows 1, 2, 3, 4

Thanks

[Aurelien]

Hi @jeffchoy

This could help you:

Manual Sorting (Move Items ↑↓ w/Buttons) || Bonus: Sequential Numbering Tips & Tricks 💡

Hey everyone This has been on my list of things to do for awhile now, finally getting around to it. (^_^) In this post I’ll walk you though how you can implement a series of actions that will allow you to move [Related Items] up/down in a list easily with a push of a button. This implementation works best when you have a parent-child relationship ---------------- Manual Sorting ---------------- How to add buttons to a table view to allow for moving items up/down in that list. [image] ---- …

[Steve]

You’d need a set of actions that identify the rows of the task list and renumbers them.