I need to add a choice field to sharepoint that has values depending on the current selection.

Question

I need to add a choice field to sharepoint that has values depending on the current selection.

Example:

if the current selection is Open then the options have to be 'open, and In progress

**Current selection   |  Possible selections**
Open                  |  Open,In progress
In progress           |  In progress,To be communicates,rework
Rework                |  Rework,In Progress

...

That way i am forcing the user to follow some specific flow

Answer 1

I think you won't get this field behavior out of the box but you can archive this by implementing your own CustomFieldType.

Answer 2

You can achieve this sort of behavior by editing your list's EditForm.aspx page and adding some JavaScript to the page.

Although I can't seem to find any examples for making dependant drop downs, there are a couple examples of modifying the EditForm to hide fields or make them readonly:

• Making a field read-only
• Hiding an entire row on the edit-form

Answer 3

So these are 2 columns out of which one filters the other?

Sounds like a cascading drop down list, there are a few (commercial) solutions out there. See http://cascddlistwithfilter.codeplex.com for a free one.

Answer 4

Just take a look a this:[ www.sharepointsnippets.com/post/2009/01/Cascading-Dropdown---Configuration.aspx ] You need not download any third party software. Otherwise, just google SharePoint Cascaded/cascading lookupthere are lot of such commercial tools.

Hope this snippet works!