Schedule Tool with Dates across the top

Question

We are using a scheduling tool that is essentially just an Excel spreadsheet in this format:

I'd love to move it into QuickBase to be able to do reporting off of it. So far, I have created tables for Date, Project and Resource (employee). I've made a Schedule table and built is as a child table of all three tables. I can bring them together as below:

My question is: can i create a report where the Dates will go across the top of the report, like in my screenshot above?

I know I'll get too much push back if I can't get it into the format people are used to. I'm okay with using Javascript to accomplish this.

jessicafeauto2 · Answer

It appears no one felt like answering my question.

I was able to SORT OF accomplish what I wanted by creating a summary report, but it only allows for numbers to be summarized, which isn't quite what I was going for. Here is a screenshot in case it helps anyone in the future or in case someone wants to contribute and help me accomplish this:

archiveuser · Answer

Since a Table report utilizes the Fields as report Columns, I don't know that you'll be able to do this without building a custom HTML/JavaScript report.

Forum Discussion

Schedule Tool with Dates across the top

Related Content

Preventing Scheduling Conflicts

Scheduling Formula needed

Distinct Dates

Formula Date Field

Date Field Formula