My app has multiple “jobs” in various stages, and each job has multiple dates for different phases of the job. This is all fine until it comes to showing the jobs on the calendar collection. Right now I use some computed columns to basically filter out the most relevant date right now and display that one on the calendar, and another computed column to set the color of the event on the calendar. Not really a problem, it works.
The only issue is: drag and drop will not work because dates are being displayed from a computed column. There’s 5 possible dates which all get filtered into one date depending on job status and/or some other criteria.
I know my explanation is a little bit vague, but I think if I want to retain drag and drop functionality, I either need to overhaul the way I deal with dates on the calendar, or run multiple calendars (I don’t want to do this), or alternatively be able to display multiple rows on one calendar AND be able to attribute a different color for each row (I don’t know if this is possible).
It’s purely a QOL issue, and the ladies in the office are transitioning from Google Calendar and do rely on this function to quickly change and organize work weeks. Right now the process is to click each thing you want to change on the calendar to bring up an overlay, and then change the date you need to change, and then submit it. Not the end of the world but it would be great if there was a way to just automatically change the date that’s being displayed (it’s already filtered).
Or alternatively just show all of the dates and have them in different colors. But since the Calendar collection only reads off one column, I’m not sure if that’s possible. Maybe an array of dates? But then how would you attribute a color to each one of them?
Just thinking out loud, any ideas are appreciated!