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.
AlexCertificati
6 years agoQrew Cadet
But the fields in the tables are not the same. He has 7 records in Table A, with 7 fields each, and he wants to take that data and create one snapshot record in Table B with all 49 fields represented separately.