Track the number of active projects
I'm sure I'm missing something simple, but have not found a solution yet. I have a checkbox to indicate the active/archived projects. I am trying to track the active projects over time. What is...
Forum Discussion
You need to add a Summary Field in the relationship... you can get a Count of Projects and filter to make sure that the checkbox is checked... Then on the parent table it'll show the count of Projects that are active
------------------------------
Ryan Stanford
------------------------------
------------------------------
Ryan Stanford
------------------------------
- MarkShnier__You
Qrew Legend
Ryan is correct, but there is a 2nd step. You need to have a dummy record to summarize up to, unless these projects alerady have a parent.
Ans then have an automation run each night record those totals in a history table.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------- Hi Mark,
I have this summary table that counts the number of records for each Status, I'm trying to get a nightly copy, could you help explain what you mentioned above? Trying to keep a daily total for each status.
------------------------------
Evan Pettit
------------------------------- MarkShnier__YouEvan P. Are the status choices pulled off a table or status choices on a relationship down to your projects table?, or is the status just a multiple choice field.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
