Recreating a Sharepoint 2010 booking calendar in Sharepoint 365

Question

Hello,

 

At work we have a SharePoint 2010 site which has an 'event calendar' which we use as a booking calendar. I have been trying to move the SharePoint site from SharePoint 2010 to SharePoint 365. I've used the SharePoint migration tool, but I am having some issues recreating the way it was used in the SharePoint 2010 on the new SharePoint.

 

Firstly, a bit of context of how it currently works. It is basically a booking system, there are two users shared by everyone, a booking user and a manager’s user. Both users are able to create events(work) which we refer to as 'tentative bookings'. The managers then go in, confirm details and that there is resources free and confirms the booking. To do this there is a hidden column called 'current user' which is a calculated column '=me' and a column called choice column called 'confirmed' with the choices 'yes' or 'no'. The form then validates off the formula =OR('Confirmed' = 'no', 'current user' = <manager login>'). This means that anyone is able to create/view the events but only the manager user is able to confirm the events.

 

In the new SharePoint this doesn't work. The user is now tied to the single touch sign on, so as in it's going to be username@domain etc. and the calculated column can no longer be '=me' as this is no longer supported.

 

I've been trying for a couple of days, between my regular work, to work out how I can create a similar effect of everyone being able to create tentative bookings but only some users being able to confirm them. Given my lack of experience with any Microsoft products more complex than excel, it has been frustrating.

 

Does anyone have any suggestions on how I would go about creating a similar effect? I've had suggestions from the office about trying to use a different system, the reason we want to keep it on a SharePoint calendar as with the migration it contains a history of all work previous done and we often need to refer back to events 18-24 months in the past.

 

Thanks

Answer 1

Hi @Colin Lewis ,

Unfortunately, after my attempts, there is no way in SharePoint Online to set a column to be edit/confirm only for some users (deemed to be managers), while other users have CREATE permission. This is because other users with CREATE permission (i.e., edit, etc.) can edit the column.

And the smallest permission level in sharepoint is item, you can't set it for smaller column levels.

I think maybe you can go to Power Apps Community and post a thread to see if you can accomplish what you want with a Power Apps custom list. Hope this information can help you！

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.