How to set up cascading drop down column for sharepoint list

since very long time i was finding solution for this approach and through googling i found following details which will be really helpful to setup cascading dropdown for sharepoint list in just few mnts !!

1) download following add on from codeplex from following link

http://customfieldcontrols.codeplex.com/

how to install this addon in sharepoint environment that i shown in following post


http://sharepointuniverseforsolution.blogspot.com/2009/11/installation-of-site-template-for.html

2) setup sharpeoint list as follow

lets say there is countries list as follow

then create a city list as follow that will be filter by selected country

3) create another list that contains cascading dropdown column as follow

lets say its name as "test"

here , Country column will be parent column and city column will be child column

so create first parent column for country by setting type as "parent control" as follow.

and then create a city column as child control as follow by assigning type as "Child Control"

now test it as follow

Select Germany and get a list of German cities: 

 

Thanks & Regards,
Dipti Chhatrapati
Enjoy Sharepoint Programming !!!

Filter By [Me] for custom sharepoint list column

we need to add a new column and create a SharePoint Workflow with the SharePoint Workflow Designer

1. Add a new column to the View

Open the Form Library Settings page

Click on Create Column in the Columns Section

Enter Assign To User as Column name

Select Person or Group as the type of the column

Click on the Ok button

1. Create Workflow

Open the SharePoint Designer

Create a new workflow (Menu File ‐>New ‐> Workflow)

Set the workflow name: SetAssignToUserField

Select the SharePoint list where the workflow should be attached to

Select Automatically start this workflow when a new item is created checkbox

Select Automatically start this workflow when a new item is changed checkbox

Enter the Step 1 name: SetAssignToUser

Select Update List Item under the Actions

               Click on This List

              Select your list on which you want to set filter

              Click On ADD

`              On set field dropdown box select Assign To User

              Click on FX button

              Source = Current Item

                            Filed = Assign To User

              In find the List item of Update list item area , set field dropdown box as Assign To User

              Click “OK” then “Yes”

              Finish your workflow.

2. Add the filter

Go back to the SharePoint List

Modify the Current View

Select Show Items only when the following is True radio button, under the filter Section

Select Assign User To from the Show the items when column dropdown box

Enter in the value textbox [Me] 

Thanks And Regards,

Dipti Chhatrapati

Set Sharepoint Column Width

you can modify the width of the column using Microsoft SharePoint Designer 2007.

The steps below:

1.    Open the view in Microsoft SharePoint Designer 2007.

2.    In the "Design" window, right click anywhere on the body of the view.

3.    Select "Convert to XSLT Data View".

4.    Click once on the column title you wish to adjust.

5.    You should now be able to drag the column to the desired width.