DanielPackman

Printing a schedule as a grid

Discussion created by DanielPackman on Feb 25, 2017
Latest reply on Feb 25, 2017 by siplus

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

Outcomes