Jane

Create a Weekly Report from a task list using Document Maker

Create a Weekly Report from a task list using Document Maker

I have a task list which monitors tasks status and manages risks. Every week, I have to report the task status to my manager. Obviously, it is inefficient to copy tasks data to the document and send the report to my manager. So, I decide to create the weekly report by Document Maker. And here […]

How to calculate lookup column in SharePoint list

How to calculate lookup column in SharePoint list

SharePoint Calculated column is very powerful when creating out-of-the-box solutions. You can use it to calculate values from other columns. SharePoint Calculated Column supports almost column types, but does not support lookup column. So if you want to calculate value of lookup column, you need to try some methods, such as SharePoint Designer workflow. This […]

Access Active Directory(AD) directly from SharePoint

Access Active Directory(AD) directly from SharePoint

We talked about reducing workload of IT guy with our product Ad Information sync to sync information from AD to a SharePoint list in another article. We also use another product Ad Administration to help us: Manage AD information in SharePoint Delegate control to other people, like department manager, to reduce the workload of the […]

Tips about Calculated Columns in SharePoint

Tips about Calculated Columns in SharePoint

SharePoint Foundation’s formulas for calculated fields are based on Microsoft Excel’s functions and syntax. How do you apply it to SharePoint and use it for your business needs? The Scenario: Employee can use SharePoint to check their Paid Annual Leave (number of days taken, number of days left and so on) and then they can […]

How to keep user information consistent between SharePoint and Active Directory

How to keep user information consistent between SharePoint and Active Directory

As we know, a User is created in the User Information List when a user is granted access to a site in SharePoint. But this list is hidden and we are not able to use the data directly. As well there may not be a lot of metadata in this list. Sometimes you may create […]