SharePoint Cascaded Lookup is a quite useful to perform cross-site lookup and filtered information from different lists of other sites.
In daily work, cascaded lookup is quite helpful to IT staff; however, SharePoint does not support this feature by default. SharePoint Cascaded Lookup is a powerful cascaded lookup tool. It not only allows users to lookup other lists in different sites, but also can easily filter field. Furthermore, SharePoint Cascaded Lookup provides two-way conversion to SharePoint default lookup type or SharePoint cross-site lookup type.
SharePoint Cascaded Lookup introduces Filter Column and Parent Column to filter field values to narrow the range of choices. As a result, users can lookup field values more quickly and accurately. Filter Column is in the same list with the looked-up column. If users set a column as Filter column for the looked-up column, when edit/create an item, the choice of the cascaded lookup column will be filtered according to the value of the Filter Column. Parent Column, which is also used to filter looked-up values, is in the same list with the Cascaded Lookup column. When users set a column as Parent Column of a cascaded lookup column, in the edit/new form of an item, the choices of Cascaded lookup column in dropdown list will be different according to the value of Parent Column.
This new product is now available for 30 days free trial, you can download it from:
http://www.sharepointboost.com/cascaded-lookup.html
SharePoint Cascaded Lookup, freely build cascaded lookup relationship between sites
Posted by SharePointBoost at 7:30 PMSharePointBoost has just released a list filter product called SharePoint List Filter Favorites. It is a small however useful tool for users to keep favorite filters in order to avoid creating filters every time when needed.
Its main features are as following:
Filter SharePoint columns as needed;
Add filter views to filter favorites menu;
Organize filters filters in the menu freely.
Have a quick look at video instruction:
Several days ago, one friend of mine asked me how to set permissions to a column. He is the IT staff, and is required to set different permissions to different users. For instance, it is a typical scenario of the SharePoint. The company is a B2B type, the number of customer increases at a high rate. The management of contract is an important part of daily work of sales department. The detailed information of the company, such as the contract date, amount, price, and other privacy information are recorded in a SharePoint list. Some contracts contain sensitive information which is only accessible to limited people. For instance, the marketing department has the permission to view the contracts, while other departments such as R&D and support department cannot access to the contents of the contract. In a word, the item permission needs to be customized. But, with SharePoint 2007 the users are unable to set SharePoint item permissions. Then, what measures can be taken to solve this problem?
Actually, it is not so difficult a task. There is a third party SharePoint add-on which can customize column permissions: SharePoint column permission. SharePoint Column Permission is a great enhancement to SharePoint 2007 permission. SharePoint column permission allows users to define column permission as needed. For instance, in the above contract scenario, with SharePoint column permission, the IT staff can easily set different users with edit, view, or invisible permission. The marketing department can view all contents of the contract but without edit permission, and the SharePoint administrator can set column “view” permission to all the staff of the department as a member group. In the same way, the sales department can be set “edit” permission and other department with “invisible” permission. One SharePoint column, one user, one unique column permission, it is SharePoint column permission that successfully sets column permission.
SharePoint column permission is not limited to certain application; instead, it can be applied in various scenarios, such as staff information management, financial date management, and so on.
30 days free trial is now available, and you can download it from SharePoint web site:
http://www.sharepointboost.com/columnpermission.html