The first post in a series of (hopefully) many to come, I want to tell you about a product that really impressed me. I am going to give "stars" to show how impressed I was.
For now, these stars are lousy images that I created my self using visio and paint.net, but if there is a volunteer amongst my readers who can whip up a nice "sharepoint tips star" design, please contact me through this "email ishai" link (you understand why I will not expose my email address?). Please upload the image to a web site (picasa, flicker and so on) so I can see it. I will publicly thank anyone who will submit an entry into this "make Ishai a star" contest.
The product of this week is "WSS 3.0 Connected Fields" by a company called InfoWise. For proper disclosure I have to say that the owner and the lead developer there are both friends of mine - but that doesn't change the fact that this product is awesomely cool - 4.5 stars.
Also known as "Master-Detail" or "Cascading Dropdowns", WSS 3.0 Connected Fields adds another field type to the types of fields you can add to lists in SharePoint. this field type operates like the built-in lookup field, but also allows you to specify a "parent" lookup.
This way you can create a master-detail connection between two fields. For example, choose a "category" and have the "product" list filter to products in that category! how great!
What is even more impressive is that they support infinite connections. so "Continent" will filter "Country" which will filter "State" which will filter "City" and so on and on.
But every friendship has its limits - and so does this solution. The only thing that bugs me about this is that the field type cannot be used in site columns and therefor in content types.
As a developer I understand the difficulty - but still I reckon that this solution can only get 4.5 stars and not 5 just because of that.
Here are some images from the infowise web site (ignore the hebrew bit in the second one - it is the "none" value for the lookup - a Microsoft localization stuff-up?):