Historical info for line chart.

Hey Everyone, 

I wanted to see If I could get some input on some options for QuickBase, so that I can change my code to accommodate these new data points. 

I have a Line Chart that displays a jobs info, 5 points creating a line to show 'Job Budget', and 'Budgeted Hours' where these 5 data points are for each phase of the job then just connecting a line between them. Then I have another single dot on the chart to show where the job is 'Currently' based on actual costs and actual hours worked.

I'm trying to see if there is a way for QuickBase to take a "Snapshot" every Friday of where the Job is at, and then I can write the code to include this, that way over time I can show that line compared to the Budget to see how far we are off budget. 

My issue is I don't know how to do this without having a bunch of records created to be able to pull those fields over to the custom code page... any thoughts from anyone on if QuickBase has something I can do to snapshot these numbers each week and be able to include in my code without a million stored? 

Thanks,
Alex

------------------------------
Alex Bennett
------------------------------