Single record report
I want to build a new report that will only show 1 record (at a time).
This report will be made up of tasks.
Each task will not be assigned to a user, yet.
When the task is the *next one - that is NOT assigned to a user - the task will appear, alone, on the report.
------------------------------
Ken Loder
------------------------------
This report will be made up of tasks.
Each task will not be assigned to a user, yet.
When the task is the *next one - that is NOT assigned to a user - the task will appear, alone, on the report.
Once the task is assigned to a user - the *next task will then appear alone on the report - and so on...
I'm assuming we can go off of the creation date of all the tasks to pick the next one in the list
or
maybe the smallest recordid could be the key to pulling 1 task at a time onto this report
The tasks are in a "Processing Task" table.
After I figure out the single record on a report - we will need an "Assign Me" button for the current user to click and add themselves to the task's Assigned To field.
I'm assuming we can go off of the creation date of all the tasks to pick the next one in the list
or
maybe the smallest recordid could be the key to pulling 1 task at a time onto this report
The tasks are in a "Processing Task" table.
After I figure out the single record on a report - we will need an "Assign Me" button for the current user to click and add themselves to the task's Assigned To field.
The idea is to allow users to pick a task and assign themselves to it.
We only want 1 task to appear at a time - so they cannot browse a list of tasks to do, and only take the low hanging fruit or high value (there are points associated with doing each task) - rather than just take what is the next task and keep the overall project (job) moving.
------------------------------
Ken Loder
------------------------------
