I’m trying to have tasks displayed in a sequence. The current default is that the most recent task shows at the end of the list of the repeating group. I want to set it so the user can manually selects a different position.
If there is 5 tasks then there is 5 positions and if someone wants to change the position of the task currently in position 4, to position 1 then the task that was previously position 1 will become position 2 and the ones below that will change accordingly.
What formula can I use to have the tasks position be manually selected and changed?
Hi there, @tenzin… there is no formula that is going to magically do what you described. Because you are saying that tasks have a priority, you will likely have to store something (almost certainly a number) in a field that denotes a task’s priority. Then, you will be able to use that field to change the priorities of the tasks when a user manually reprioritizes them, and you can sort a repeating group by that field to show the tasks in the appropriate order.
Anyway, just some food for thought there, and I hope it helps.
Hey I guess I could have been specific. I was curious how to give it a number. I figured out I can make the tasks order number with this formula.
order number = search for tasks: count + 1
The issue I’m running into with this is that it is counting all of the tasks and I want it to only count the tasks in the project that the task is being created in. I tried adding this constraint but it doesn’t work.
I thought this would work sense I have the state of the page set to a project and the tasks data field for “parent projects” tasks is project parent = state of the page’s project. That all working but I have a second action after Create a new task, which is make changes to that task and set the order number with this formula.
order number = search for tasks: count + 1
Constraint: Project parent = index’s project
It’s still counting from all tasks instead of the tasks inside that project. Any idea what I need to change?
What you are describing sounds like it should work. I guess you could try setting the constraint to Project parent = Result of step 1's project parent, but again, I don’t see why your setup isn’t working. Any chance you have a privacy rule in place that is getting in the way of the search? Have you tried running the workflow in step-by-step mode to see if the debugger can give you a clue as to why it’s not working?