Supporters of End User
Web

SharePoint: SPCascadingDropdowns Demystified (or Mystified, Depending on Your View)

 
Item is currently unrated. Press SHIFT+ENTER to rate this item.1 star selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+ESCAPE to leave rating submit mode.2 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.3 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.4 stars selected. Press SHIFT+ENTER to submit. Press TAB to increase rating. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.5 stars selected. Press SHIFT+ENTER to submit. Press SHIFT+TAB to decrease rating. Press SHIFT+ESCAPE to leave rating submit mode.
Categories: 

Marc D AndersonGuest Author: Marc D. Anderson
http://mdasblog.wordpress.com

In my  jQuery Library for SharePoint Web Services, one of the most popular functions is $().SPServices.SPCascadeDropdowns.  The SPCascadeDropdowns function lets you set up cascading dropdowns on SharePoint forms. What this means is that you can enforce hierarchical relationships between column values.  This is sometimes called connected dropdowns or linked dropdowns (or probably other things I haven�t run across yet).

The function uses the GetListItems operation of the Lists Web Service to refresh the allowable values based on relationships which are maintained in reference lists. By implementing this function, you can remove all of the coding requirements to manage the hierarchical relationships (once it is in place) and let your users manage the content.

Comments

SharePoint Daily

SharePoint: SPCascadingDropdowns Demystified (or Mystified, Depending on Your View)

SharePoint 2010 Dev Center Adds BCS Resources; Microsoft On Proposed ‘Open Internet’; Is Cloud Computing SaaS?... Top News Stories SharePoint 2010 Dev Center Ramps Up, Adds BCS Resources (Redmond Developer News) Microsoft...

Posted 30-Oct-2009 by SharePoint Daily
Fred Morrison

SharePoint: SPCascadingDropdowns Demystified (or Mystified, Depending on Your View)

The point you make about StaticName vs. DisplayName is the reason I *ALWAYS* enter new column names *WITHOUT* spaces or special characters the first time. For example, I enter ProductDescription as the column name via the UI and then go back and change it to Product Description. That way, the static name never gets "cluttered up" with those nasty looking _x0020_ things. Similarly, I would type in TermsAndConditions initially to set the StaticName and then immediately change it to Terms & Conditions to get the nicer DisplayName. I'm sure I'm not the only SharePoint developer who follows this convention. It's also a good thing to teach power end users.

Posted 12-Dec-2009 by Fred Morrison
Marc D Anderson

SharePoint: SPCascadingDropdowns Demystified (or Mystified, Depending on Your View)

Thanks, Fred. I recently posted to my blog about StaticName vs. DisplayName, and a few of us have been tossing around thoughts about it if you are interested. See http://mdasblog.wordpress.com/2009/12/11/staticname-versus-displayname-on-sharepoint-lists

I think I may try to rewrite the post for EUSP, if Mark's interested in it.

M.

Posted 13-Dec-2009 by Marc D Anderson
Perry

SharePoint: SPCascadingDropdowns Demystified (or Mystified, Depending on Your View)

Internal name and static name are not synonyms; they are actually two separate properties of a column (called an SPField in the API world). Usually they are the same, or at least start out the same; however, while both internal name and static name can be later updated in a site column, only the static name in a list column can be later updated.

I tried to describe a bit of this in a blog posting of my own: http://www.sharepointlessonslearned.com/blogs/blog1.php/2010/02/16/the-three-names-of-a-site-column

Posted 03-Mar-2010 by Perry

Notify me of comments to this article

E-mail:
   

Add Comment

Title:

 
Comment:
Email:

   


Name:

 
Url: