2 Replies Latest reply on Feb 25, 2017 8:04 AM by siplus

    Printing a schedule as a grid

    DanielPackman

      I have a set of classes. Each class has information such as a title, a day, a time and a room. Each class can have one to several teachers associated with it. In list view, I have a layout that works well for printing this information out. I have a portal that refers to the teachers. The layout refers to these lessons and in list view, each class prints out nicely with associated teachers.

       

      What I'd like to do is print this out in a grid with time the vertical axis and room the horizontal one. Ideally, the two days would print out front and back. If I set up a layout in form view and have it refer to a specific group of classes (each year there is a two day workshop), I can print a title with overall information such as the day for all the classes on the sheet. And I can divide the page into a grid using filtered portals to print out specific information about each class in the appropriate grid (such as class title). But I really need to put a portal in a portal then to include the list of teachers. I can imagine a horrid workaround where I have a variable of teachers within each class with multiple instances and just redo the database structure. Can I do this with the current structure?

       

       

      April 1, 2020 Workshop

      TimeRoom 102Room 103
      Room 104Room 105
      8:30

      Logic 101

      1. Socrates
      2. Plato

      Music 101

      1. Bach

      Art 101

      1. Michelangelo

      Astronomy 101

      1. Tycho Brahe
      9:30

      Math 101

      1.Euler

      2.Lebesgue

      Music 102

      1. Beethoven
      1. Rembrandt

      Astronomy 102

      1. Galileo
      10:30

      Logic 102

      1. Turing

      2. Russel

      Music 103

      1. Brahms
      1. Manet
      2. Picasso
      3. Corot

      Astronomy 103

      1. Fritz Zwicky
      2. Jesse Greenstein