Need Special Scheduling Report Help

Question

I need a special Scheduling Report like the one I mocked up in Excel and have attached to this request.

I have followed some of the requests for help with similar needs and the consensus seems to be it can't be done in native Quickbase. I have searched among the various tool vendors looking for something like this and have not found anything close.

It looks like i am going to have to write it myself I am guessing that it will have to be done in Javascript. I am developing this tool for my son in my spare time. His business is not cash rich, so that leaves the report development to me. I have some coding experience, but none with Java or Javascript

Can anyone provide some guidance on the beast way to approach this? If it is in Javascript, can you recommend libraries that are fairly inexpensive that will help in this development?

Thanks for your help!

quickbasecoachd · Answer

Did you try Veil Sun. They have a drag and drop scheduling add in..

https://www.veilsun.com/vel-qscheduler

Or MCF

https://www.quickbase.com/partners/ad...

Or Juiced

https://www.juicedtech.com/scheduling...

claudebowens2 · Answer

This type of form is possible to create. I'd love to discuss this with you. bowencl5157@gmail.com

keithjusas · Answer

Hi Jeff / Mark,&nbsp; we just recently released some additional functionality in our XL Docs add-on to help generate Scheduling / Gantt style output files.You can demo that here:&nbsp;&nbsp;https://juicedtech.quickbase.com/db/bneztjaka?a=dr&amp;r=h&amp;rl=kgpClick on the Scheduling / Gannt tab on this record and you'll be able to generate an Excel file that looks like thisData is coming from our Projects and Tasks tables in this exampleKeith

jeffmickelsen · Answer

Keith,I appreciate your taking the time  to respond to my request.&nbsp; I may be  missing something, but I did not see anything that will meet my need.&nbsp; To summarize, what I need is similar to a  Gant chart with these characteristics:       A report with dates as       the X axis and DumpsterID as the Y axis.   Each DumpsterID may have       more than one assigned date range.&nbsp; For       instance DumpsterID 15-10 may be scheduled for 8/2-8/6, 8/12-8/16, and ...   Each DumpsterID will       only be found in one row regardless of how many assigned date ranges exist.   I would like to be able       to color code each bar (representing one date range) depending in Dumpster       size (first two characters of the DumpsterID) and whether the start date for       the date range has passed (already deployed).   I would prefer to build       for up to 500 DumpsterIDs.    I can easily create the macros to build the report  by merging cells, filling backgrounds, providing captions for each date range, ....&nbsp; My challenge is how to create an .xlsm file  to download to excel.&nbsp; I guess I could  create a macro, put it in the Excel global location, and the put a button to  invoke the macro on the toolbar, but I still don�t know how to create an .xlsx  file with the data to download to Excel .&nbsp;  I can download the file as a .csv and then have the macro create the  .xlsx file.&nbsp; Sorry for the rambling, but  I am thinking as I write.&nbsp; See the file attached to the original request for an example.    With all of this said, I need this report  available on mobile devices and macros are not yet supported on mobile  devices.&nbsp;    Am I missing something in your toolset?&nbsp; If so, can you help me see what I am missing?&nbsp; &nbsp;

keithjusas · Answer

Jeff,&nbsp; how is your application structured?&nbsp; Do you have a single table that stores the Dumpster IDs and their assigned dates or do you have the assigned dates in a child table connected to the Dumpsters table?

Forum Discussion

Need Special Scheduling Report Help

Related Content

Preventing Scheduling Conflicts

Scheduling Formula needed

Extract Text Between 2 special characters

Restful API Report digesting JSON

Summary Reports