Organizing data for graphing
I have an app that totals up billings and costs by calendar quarter by project. There is a Projects table that includes fields for each calendar quarter's total billings and total costs. For example, ...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendSo your form has say 40 fields hard coded for a particular quarter for 10 years, so say 40 fields.
If you want to chart this you will need a process to create child records from those fields, so 40 child records for each project.
You will need to create a child table and then create a formula URL button which would, for example delete all the child records, and then trigger an Automation which would run 40 saved table to table copies to copy the Projects into the child table and map the correct value into the table along with a field to indicate the YYYYQ.
So each time that you wanted to run the Report, you would need to push the button to run that process and then run the report.
I can help a but more here if you want to tackle this or contract me directly by email for one on one on one assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
If you want to chart this you will need a process to create child records from those fields, so 40 child records for each project.
You will need to create a child table and then create a formula URL button which would, for example delete all the child records, and then trigger an Automation which would run 40 saved table to table copies to copy the Projects into the child table and map the correct value into the table along with a field to indicate the YYYYQ.
So each time that you wanted to run the Report, you would need to push the button to run that process and then run the report.
I can help a but more here if you want to tackle this or contract me directly by email for one on one on one assistance.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------