Thanks, but the problem I'm having is getting those counts summarized in one field. I can't get it to summarize all the tasks whose FirstDayOfWeek([Date Completed]) = the Scorecard Week Date.
The result I get when trying to do that only counts tasks whose FirstDayOfWeek([Date Completed]) = today's Date, which of course isn't going to work. The weird thing is that for Scorecard records that are over 2 weeks old, the data works OK, but not for the latest two Scorecard records. So the summary for Week 8/18/2019 is an accurate count, but for 8/25 and 8/31 return zero. That's if I set up the Tasks as children of the Week.
------Original Message------
Automations to the rescue. This used to be difficult to do later play or impossible but now it's super easy as 1,2,3
Step 1. Make a saved table to table import to copy from your source table which has your summary records that you want to snapshot into a static table
Step 2. Set up an automation to run that saved import say every Sunday.
Step 3. Y'ur done!
Now I'm not actually sure if you have a source record to use to copy into your static table but you should be able to create a record in day a new single record table which will summarize the number of open tasks or the number of test started or the number of test completed, whatever kind of stats you want onto that single record.
post back if you have trouble getting your various counts summarized onto a record.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commarkshnier2@gmail.com
------------------------------
Qrew Legend
