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 […]

How to create a Purchase order using Collection Column

How to create a Purchase order using Collection Column

SharePoint Collection Column provides an easy way to display one item and its related items or sub items in one page. Without modifying the item form in SharePoint designer, the related or sub items can be displayed in a table. Using Collection Column, users can easily bulk add, edit and delete related items in the […]

Calculated Boost Field Use Cases

Calculated Boost Field Use Cases

Calculated Boost Field is a field which enables you to do calculate based on other columns like SharePoint Calculated column. With Calculated Boost, you can design powerful formula and complete complicated calculation. Calculated Boost supports more column types than SharePoint OOTB calculated column, including People, Lookup, Note, ID, Content Type etc. Even better, you can […]

Solution for error message: DC - error message:System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

Solution for error message: DC – error message:System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

Sometimes we got an error message when we synchronize message from Oracle?to a Sharepoint list.   And you probably tried all the approaches by google it, and still did not work. The solution from us is taking the steps: 1 Install Oracle client to every single one of the web front end server. 2 Go […]

Why is there always the tips "can not change password" for password change?

Why is there always the tips “can not change password” for password change?

It happens sometimes that when we were try to change the user’s password by password change right after the product installed, there is always the error message like this: The first idea that pops out in our head is there is something wrong with this product, but in most case it’s caused by the password […]

How to set remind message to a user 7 days before his birthday every year

In sharepoint 2010 or sharepoint 2013, Alert Reminder Boost allows us to send a remind message on a specific date, by different time intervals, by different conditions, and if you like, you can even set the if else condition to realize that.. How to send email message days before a specific date, which might be […]

Cascading and Cross site in one go

Cascading and Cross site in one go

Cascading function has been required by many customers so far, and it’s a common requirement in the SharePoint market as SharePoint itself doesn’t support this. Why we need cascading and cross site function: 1. Avoid selecting redundant data 2. Improve efficiency 3. Look up records from different sites under one site collection 4. Locate desired […]