Forum Discussion
AlexBennett3
Qrew Trainee
So I would have to break up my Job record with all the data into multiple to be able to show all of them up on a Timeline Report?
------------------------------
Alex Bennett
------------------------------
------------------------------
Alex Bennett
------------------------------
BlakeHarrison
4 years agoQrew Captain
If you want to show the Start / End time for each Department on a Timeline report, each Department would have to have be a child record to the Job and your report would be done on that child table.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
- AlexBennett34 years agoQrew Trainee
So this is the layout of my app, there are 7 departments that I'm trying to display on a calendar or timeline to visually display their durations in 4 phases. Right now this Schedules table is a child of my Jobs table. So you're saying I'll have to Split each department into separate records? If so, how would I display all the records needed separately on a Timeline Report?
------------------------------
Alex Bennett
------------------------------- BlakeHarrison4 years agoQrew CaptainUnfortunately, this is the downside of building all of this on a single Schedules table. If you are capturing the same information for each Dept/Phase combination, it's better to set that up as a single record and use the built-in Summary fields to calculate any totals that you may need. Essentially, you would end up with quite a few more tables, but your application would be structured for growth.
So, essentially, you need a structure similar to this:
In about 30 minutes, I put together an example application with the following tables:
And produced this:
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- AlexBennett34 years agoQrew TraineeSo If I only have 2 Tables being Jobs and Schedules, how hard would this be to convert over to split these up? When all my data on Schedules is either being Lookup fields, and formula fields calculating these fields for totals. Now that I have this built out I'm not sure how to go about breaking it up without just restarting completely. I do appreciate your help and input though! Thank you!
------------------------------
Alex Bennett
------------------------------