Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoRyan 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
------------------------------
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
------------------------------
EvanPettit
4 years agoQrew Member
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
------------------------------
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__You4 years ago
Qrew Legend
Evan 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
------------------------------- EvanPettit4 years agoQrew Member
The status are inputted as part of the record, when it changes queues, it changes the status. It's a part of the record.
Evan Pettit
Technical Operations Project Analyst
Supply Chain Management
214-904-7347
******* CONFIDENTIALITY NOTICE *******
This e-mail message and all attachments transmitted with it may contain legally privileged and confidential information intended solely for the use of the addressee. If the reader of this message is not the intended recipient, you are hereby notified that any reading, dissemination, distribution, copying, or other use of this message or its attachments is strictly prohibited. If you have received this message in error, please notify the sender immediately and delete this message from your system. Thank you.
- MarkShnier__You4 years ago
Qrew Legend
I'm asking if the status choice field is a simple multiple choice field or is it chosen from a relationship to a master parent table of Status choices.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------