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 jo...
Forum Discussion
But from my understanding, I'll have to have a record for every point of data to display on my Custom Coded Line Chart correct? I just don't see any other way. For example, if I want to get a weekly current for that job to display on the code, I'd need a field to reference from for the code. So if I have 50+ jobs, each going from 3 months to 5 years in length, I'd end up having a million records created to be able to display that data?
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendYou would need a record created for each weekly snapshot. An Automaton would run a saved Table to table copy each weekend to copy the jobs into the History table. But you would only copy a few fields that you need for the charts and they can be children of the job, so you don't need to copy any fields that can be looked up, like [Job Name].
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------