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 ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendYa, I've heard of this one before. The "no cherry picking" situation.
Make a a new table called Focus Task. Add 1 record to that table and then prevent any, including Admin to add more records.
Make a relationship back to Tasks based on a reference field in tasks which you will set up called
[Link to Focus Task (=1)]
it will be a formula numeric with a formula of
1
Then make a summary of the minimum [Record ID#] of tasks subject to the filer that the task is unassigned. Call the field
[Record ID# of Next Unassigned task]
Then look that up down to Tasks.
Lastly put a filter on a report where
[Record ID#] equals the value in the field [Record ID# of Next Unassigned task]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Make a a new table called Focus Task. Add 1 record to that table and then prevent any, including Admin to add more records.
Make a relationship back to Tasks based on a reference field in tasks which you will set up called
[Link to Focus Task (=1)]
it will be a formula numeric with a formula of
1
Then make a summary of the minimum [Record ID#] of tasks subject to the filer that the task is unassigned. Call the field
[Record ID# of Next Unassigned task]
Then look that up down to Tasks.
Lastly put a filter on a report where
[Record ID#] equals the value in the field [Record ID# of Next Unassigned task]
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- Thx Mark.
In the new Focus Task table, you stated that I must create a solo record.
Can you elaborate on the field type and content that I'm going to create?
------------------------------
Ken LoderTesting
------------------------------- MarkShnier__YouActually, you just need to create a record. It will be [Record ID#] = 1. You do not need to create any fields.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- 10-4,
thx again
------------------------------
Ken LoderTesting
------------------------------
