Forum Discussion
QuickBaseCoachD
6 years agoQrew Captain
It's not clear from your post if you want to create a Daily History record of all 7 Team Records or some sort of totals record.
But regardless, the method is the same and easy.
You set up a saved table to table copy to copy from Table A to table B. Then set up a scheduled Automation to run Daily or maybe weekly 5 days a week from Tuesday thru Saturday. The Automation will trigger some time shortly after midnight.
If you want to copy all 7 records, then you would just set up the Saved table to table copy to copy all 7 records. If you just wanted to copy the totals, then you would need to create a single daily totals record in a new table, relate it to all records in the Teams table and use summary fields to get your totals.
But regardless, the method is the same and easy.
You set up a saved table to table copy to copy from Table A to table B. Then set up a scheduled Automation to run Daily or maybe weekly 5 days a week from Tuesday thru Saturday. The Automation will trigger some time shortly after midnight.
If you want to copy all 7 records, then you would just set up the Saved table to table copy to copy all 7 records. If you just wanted to copy the totals, then you would need to create a single daily totals record in a new table, relate it to all records in the Teams table and use summary fields to get your totals.
QuickBaseCoachD
6 years agoQrew Captain
... you will need to create a field in table called [Yesterday]
with a formula of
Today()-Days(1)
Use that field to populate the Key field of the Table B Audit logs the Automation will run each day about midnight "the next day".
with a formula of
Today()-Days(1)
Use that field to populate the Key field of the Table B Audit logs the Automation will run each day about midnight "the next day".