I currently create event schedules like the following in Excel, with hour of day going down, stage names going across, and event blocks sized accordingly based on time length.
This is a fairly manual process right now to change this schedule each day. I edit each cell with new event details, change size of the block to match the event timeframe via merging cells, and then color code the block according to the stage.
My dream would be to enter in event data e.g. artist name, time frame, and corresponding stage, in an easy-to-fill form / database, and have it auto-create a view similar to the screenshot above.
Is this possible with Airtable? Or any other ways Airtable can make the current process less manual? Thank you.
Welcome to Airtable Community !
You can use the Airtable Calendar view to have something similar to that, it will not be the same though. Attached is an example.
Thanks Mo! This is almost there. Do you know if there’s a way to add column headers up top of the calendar view to reflect the venue name?
Welcome Carson , my pleasure
There is no way to add a header, this is why I said almost similar
To elaborate, the color-coding that @Mohamed_Swellam applied is one way to distinguish between venues. Another possibility is to tweak the display name of each calendar entry to preface the event name with the venue name, in addition to the color shift.
It should also be noted that the only reason that Mohamed’s example appears in nice clean columns is because of how the event times happen to overlap. With a different event arrangement, you could have events in the same “column” at different venues, which would make the color coding that much more important.
Thank you @Justin_Barrett and @Mohamed_Swellam for your replies.