Different type of view in SharePoint document library (Root & Sub Folder)

When we want to have a default view at the root level of the library and different default view for subfolders.
By default, the default view will be applied to the whole document library but when we want to have a different view with its own sorting, filtering, etc. we can use the method below:
Continue reading Different type of view in SharePoint document library (Root & Sub Folder)

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

Part 2: Steps to display the item based on the month & year of its reminder date

1. ​Create 2 more columns with the steps in Part 1 (Step 1 – 5). Then, named the 2 columns as “​Reminder Start Month” and “Reminder End Month” with the formula:-

​Reminder Start Month (First day) ​Reminder End Month​ (Last day)
​=DATE(YEAR([ReminderDate]),MONTH([Reminder Date]),1) ​=DATE(YEAR([Reminder Date]),MONTH([Reminder Date])+1,1)-1

Continue reading How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-2)

How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-1)

One of our customer required to calculate the item’s reminder date automatically based on the item’s expiry date and display the item that its reminder date is placed on current month & year.

The reminder date will be the date which is 3 months before the expiry date. For example:-

Continue reading How to calculate the reminder date automatically and display the item based on the month & year of its reminder date (Part-1)

How to enable custom script for SharePoint Online (Office 365)

Office-365-adminI would like to share my experience with my recent customer in office 365, we manage to register them company in Office 365, but for some reason, after we create new site collection we are not able to add new content editor,  adding custom script and another big problem, we are not allowed to modify the master page in SharePoint Designer 2013, I was confused about all of this problem .
So started to do some research on google and finally found the solution;
Continue reading How to enable custom script for SharePoint Online (Office 365)