Calendar
17 TopicsSharePoint List Calendar View Conditional Formatting
Hi all, I've been spinning my wheels on this one. I have created a calendar view from a SP list and want to color code calendar items based on the event type (field = "Event_Type"). They selection list is formatted as radio buttons. I've written the following JSON and input into the Advanced View under Conditional Formatting. I've tried everything I can think of to de-bug but it seems the code is correct? Yet it isn't working: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/row-formatting.schema.json", "additionalEventClass": { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Vacation/Out of Office" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgRed' , 'sp-css-backgroundColor-BgDustRose sp-css-color-DustRoseFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Training" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgGreen' , 'sp-css-backgroundColor-BgMintGreen sp-css-color-MintGreenFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Onboarding" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgBrown' , 'sp-css-backgroundColor-BgGold sp-css-color-GoldFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Holiday" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgTeal' , 'sp-css-backgroundColor-BgCyan sp-css-color-CyanFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Meeting" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgDarkPurple' , 'sp-css-backgroundColor-BgViolet sp-css-color-VioletFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Event" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgBlue' , 'sp-css-backgroundColor-BgCornflowerBlue sp-css-color-CornflowerBlueFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Board" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgGray' , 'sp-css-backgroundColor-BgLightGray sp-css-color-LightGrayFont')+' sp-field-fontSizeSmall'", { "operator": ":", "operands": [ { "operator": "==", "operands": [ "[$Event_Type]", "Wellness" ] }, "=if(@isSelected == true, 'sp-css-color-WhiteFont sp-css-backgroundColor-BgDarkGreen' , 'sp-css-backgroundColor-BgSage sp-css-color-SageFont')+' sp-field-fontSizeSmall'", "" ] } ] } ] } ] } ] } ] } ] } ] } }Solved12KViews0likes10CommentsCalendar alternatives, 3rd party solutions
Anyone aware of a third party app or solution for a calendar? The SP calendar is underwhelming and highly limited. We are looking for alternatives? Also, in the store there's a banner notice saying in that Microsoft will no longer allow "add-ins" as of April? Is this all 3rd party solutions? apps?Solved1.1KViews0likes5CommentsAdd to Calendar Link from SharePoint List View Not working
Dear SharePoint gurus- I am trying to create an "add to calendar" link that will add a Teams meeting / session to a user's calendar from a SharePoint List that I'm displaying as in a custom gallery view. I've been trying lots of ways to do this, with none of them working. Most recently I've tried to implement this https://github.com/pnp/List-Formatting/tree/master/column-samples/generic-scheduling-link from Github but I'm missing something because although the icon display works fine, the h refs/"deep links" that are meant to open Outlook and/or Teams to create events, instead return an error with my list url plus Invalid%20Date at the end. I'm not totally sure if my problem is in the Formatted Date field, or in the Start and End fields themselves. Also, the "deep links" contain + symbols. Is that an issue? I've read that it's supposed to contain %20.... I'm feeling totally lost. Can anyone help? This seems like a simple thing but I guess not??1KViews0likes1CommentCalendar Overlay - user permissions
Hi! I have a master calendar that I want to add a bunch of calendars to using Calendar Overlay, but one of the calendars is confidential. If I overlay this confidential calendar, will others (who don't have access to the confidential calendar) see the confidential calendar events? If so, is there any way to prevent others from seeing the confidential events (except those who already have permissions to see it)? Hope I'm making sense, but any help would be greatly appreciated! Thanks, B1.7KViews1like3CommentsCalendar on Sharepoint Modern shows dates format, not actual date
Hello Community, I added a company calendar on the startpage of our sharepoint. Events are shown correctly and everything seems workin fine, but the year, the first day of every month and the current date are always shown as the format it should be in rather than the actual number. As in, the first day of may is shown as "a Mai" (german), the year is shown as "JJJJ" (again, german for "Jahr" I suspect) and the current date is also shwon as "a Apr.". I attached a picture to show you the errors. Can anybody please advise on how to fix that? I tested it on different browsers, different pcs and different accounts, all to the same result. Best regards Peter Herold1.2KViews0likes1CommentChange Event Web Part to Calendar view
Hi All, In current SharePoint Online, the Event web part still has not had a modern calendar view. If I need to show the event in calendar view, I need to use the classic Event Calendar. I understand that I can create a calendar view using SharePoint list. But I have no idea how to add the event into a SharePoint list and change it to a calendar view. Anyone has the same situation as me?? I really don't understand why Event web part cannot change the display style to a calendar.5.1KViews0likes4CommentsHow do I display a calendar in SharePoint communication site?
Hi, I have created 4 calendars for four company vehicles as shown in the image below. How do I display these calendars as one calendar on a SharePoint site so staff can see what vehicles are booked out at certain times on certain days? I am trying to use this as a resource management calendar so staff knows what company vehicles are available for use at certain times. Thanks4KViews0likes1CommentModern Calendar not showing times and dates correctly
Help! I have added a modern calendar to our site but am having a couple of issues with it. The first is that week long or multi-day events are not showing for the entire period. For example, New Hire training for a week is showing correctly when you open the event. But on the calendar it's only showing up on the last day. Do we have to enter the event on each date or is there a way to show the span of time? The second issue is that when you hover over an event it shows the start and end time as the same time, for example 11 AM to 11 AM instead of 11 AM to 12PM. Sorry, no screen shots of that. I have searched here pretty much all day and used Google, but not finding anything on this problem.2.5KViews0likes2CommentsSubscribe to Sharepoint Calendar or show in free/busy
Hi! I'm using a SharePoint Team Site (in conjunction with Microsoft Teams) for the university band I direct. I used to use a Google calendar with all of our rehearsals and performances that they could subscribe to, but we are a Microsoft campus. So, I added everything to our group calendar this year since I'm going all in on SharePoint and Teams. It shows up in Outlook and I can overlay it into my calendar. However, I'd like it to affect my meeting availability (theirs, too, but I think I get a lot more meeting requests based on Outlook availability than my students do). I don't want to duplicate my effort by adding it all to my personal calendar, too (ran into this adding the Google calendar to Outlook last year but hoped it would be different with it all in Microsoft). I know I can add each event individually to my calendar but there are 117 events. Looking back I probably should have made them all meetings and invited everyone. Perhaps next year I will. In the meantime, I have two questions: Is it possible to batch add all events from a group calendar to one's personal calendar a. I'm 99% certain it is not possible... but is it possible to have a subscribed calendar OR the overlaid group calendar affect free/busy time in my personal calendar? If so, that solves the first problem. Is it possible for people to subscribe to a Sharepoint group calendar (say, for my students who refuse to let go of Google)? Thanks! -Casey2.5KViews0likes2CommentsSharePoint online calendar overlay not working
I built a team calendar that has 7 overlays color coded to several tools that they use. The team wanted to add a couple of more tools to this calendar. I added the new categories and two new views with color coding. The new Views/Categories appear in the List Settings as "Show in All" and are available when an item is added to the calendar. However, when you return to the main calendar, those new items do not show up on the calendar. If I go to All Events, I can reassign the item to a different category and it shows up fine. Any ideas?3.4KViews0likes1Comment