I think you can get what you want with a set of portals with portal filters to get your columns of data. That will avoid the scripted data manipulation you are describing here.
I thought of that at the beginning but I dismissed it because I do not know how to gang the partals. They will be displayed side by side and the time headings to the left, I will need to do something about scrolling, if I scroll one portal I need all the others to move accordingly so all will be located at the same time slot.
IF I CAN DO THAT IT WILL BE GREAT. Can you give me a hint.
I thought I include an image of the screen I am talking about so I am very clear
here it is
I failed to send you an image sorry
images must be of type jpg, gif or png. Any other formats will not appear in the forum when you upload them. (You can upload them to a file share site though and post the download link here in your next post.)
Can you try that again with a larger image? Even when I zoom in, I can't read the column headers to figure out what kind of data you are entering and what determines which column should display a particular value.
hopefully this is a larger image
It came out to be the same size I do not know why but any way the headings of the columns are the teachers names and along the left side are the times 3:00, 3:15, 3:30 etc and in the grid the appointments are displayed with the student name on top and the colored appointment spans as many time slots as needed so if the appointment is 45 minutes it spans 3 slots because each time slot is 15 minutes
to explain more, when you click on any appointment there is a hidden button which runs a script to calculate the time and teacher, in other words it identifies the appointment. Then the buttions at the top will do different processing for that appointment. Like cancel or move or copy ... etc.
to explain more when you click on any slot there is hidden button twhich runs a script to identify the time and teacher. then the buttons on top allow you to do different processing for that tims slot like book or cancel etc.
When I click on it. It's much larger when it opens and easy to read. Thank you.
Do you have this relationship?
People::PeopleID = People_appointment::PeopleID
Appointments::ApptID = People_appointment::ApptID
If so, you can set up a filtered portal for each person to get your columns of appointments. Let's add this table to the mix:
TimeSlots::Date = Appointments::Date AND
TimeSlots::Time > Appointment::StartTime AND
TimeSlots::Time < Appointment::EndTime
Now you can create a list view layout based on TimeSlots. Each row in your screen shot would be one record and each intersection of Teacher and time slot is a one row filtered portal to Appointments. You can perform finds to pull up the schedule for any given day or range of dates and times.
For the first column, your portal filter might be:
People_Appointment::PeopleID = 7 // 7 is ID number for "Barbara Ferchuk"
The second column portal is identical to the first, but you use a different ID number to show appointments for Brooke Foster and so forth.
Note that you can use global variables or fields in place of the literal ID numbers. Then you can turn the column headers into pop up menus to use to select a person for that column of filtered portals.