Skip to main content

Hello all:

I have a table that stores our department's class offerings schedule. The important fields are:

  1. Lecturer's name
  2. Course number 
  3. Day of the week (Multiple select - as there can be multiple days the class is offered) 
  4. Start time of the class (the date does not really matter here; We only care about a typical week)
  5. Duration of class (in minutes) - helps to compute the end time of the sessions. 

I would like to generate a view that shows us the Weekly Schedule that is “date Agnostic” for an entire semester. The columns will be the weekdays, and the rows will be the time frames of each day (running from 7am to 9pm). I would like the classes to be filled into a “calendar-like” view based on their time and day of offering. This will aggregate across all classes, and i would also like to apply filters to it. 

We achieved it in Tableau, but it would be nice to have it in Airtable, where all our data are typically stored. 

Thanks for your help. 

Hmm, I think you’d actually have to create one record per day per class in order to get this into a Calendar view, and the only way I can think of doing that is via a script I’m afraid.  If you’ve got someone who knows JavaScript on staff then they can whip something together for you

Hopefully someone else has a better idea!

Thanks. If that requires setting up the data differently, we could try to do that, with one line per meeting time, as opposed to one line per course. I do not know how to apply the code to it within Airtable. But worse case, we can do it outside AirTable and bring it back.

 

Having said that, for this alternate structure, how would we go about structuring the view? 

Hey ​@TzachiZach,

If you do not want to create one record per day per class for the full semester/year you might still want to include date, but get the date automatically updated for the same day of the week of the following week (triggered on a scheduled basis every Saturday for example). You can easily calculate this date with a formula (date time difference adding 7 days), and then just use such date value to stamp it via the automation on the actual date field.

Mike, Consultant @ Automatic Nation

Hm, could you provide a screenshot of your output in Tableau, and a screenshot of your current data?  How the view’s set up sometimes depends pretty heavily on the desired output, and so knowing the output format would be really helpful!

This is the visual that I am trying to reach in AirTable. I am ok with it being an interface, and I made some progress there after your guidance of creating one record per class meeting, although I do not have that nailed fully. The interface in Airtable would look something like this

 

 

Although now this is only partial, and only the start times are correct. The end times should be a function of duration (in mins). 

Thanks for your help. 

 

 

The data looks like this. As you see, I chose just one date for a session (so it is ignoring the second date), but that is fixable. Also, End Time is a formula but it has some issues with Time Zone that I need to solve. 

Terms & Conditions