I’ve built an agenda app with events that have locations and start/end times. Right now it’s simply a list of events in order, but I’d love to display this in more of a kanban style, with events grouped by location and placed according to their time (with gaps between events when there are gaps). Is this possible with either kanban or another component? When I try kanban, it it bunches the events together instead of placing them according to their start or end time. A table seems like it would work as a less aesthetically pleasing option, but nothing happens when I identify a column header.
Hypothetically, something like this is what I want:
(notably I also want the kanban to sort by the start time of the event, and it doesn’t seem to want to do that…)
I don’t think that’s possible with any native components.
Thanks! I sort of got what I wanted using the data grid component but the problem now is I don’t have events grouped together if they have the same start time (i.e. in the example above, Event 1 and Event 3 are in two separate rows in the grid with the same time, so it looks like they start at different times). TBD on whether I can figure out anything there; might try creating a new table to reference. (still won’t be perfect since a number of events are offset by as little as 5 or 10 minutes, but would be better at least if events with the same start time were grouped into a single row)
How do you achieve part of that with data grid? Just curious.
I wound up creating a new table with the various locations (Room 1/2/3/4 etc) as columns, then did an if statement in the google sheet to match the events to the proper column, and set up a data grid with Start Time and each Room as the column names.
Then I had to manually de-dupe rows with duplicate start times (in my screenshot above, Event 1 and Event 3 have the same start time, but the data grid displayed this as two separate rows; I had to move them into the same row to show them side by side). If there’s a formula to do that de-duping, I’m all ears lol - chatGPT and google were not helpful.
But it’s still not exactly what I’m looking for. I have a lot of events, and they don’t have clean start times like my screenshot above (one might start at 10:00 and another at 10:05 - these show as different rows, which gives the impression they start at entirely different times instead of mostly overlapping). What I really need is a daily calendar view with columns for different locations so that the start and end time of each can line up with the time of day according to their location, showing the overlap. The Calendar component doesn’t organize things by column like that so far as I can tell, and with eight distinct locations, it ends up looking like a jumbled mess, even with coloring each location distinctly.
Yeah, that’s a lot of effort for an output that’s still not what you expected.
I don’t think I have heard any upcoming updates to the calendar component, though.
