.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

What lists and what column types allow for setting "column default value settings"

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
There is a new setting for lists in 2010 called "Column default value settings". What lists does this setting apply to (I think just lists with a base template of Document Library)? And for what column types is it available? It was available on a "Single line of text" column but not a lookup column. Thanks in advance!

View Complete Post

More Related Resource Links

Duplicate column names from forms in SharePoint lists



I'm in the process of migrating from a WSS 2 site to WSS 3/MOSS. On the old site I used an Infopath 2003 form for absence requests. During the migration I now use Infopath 2007. There wasn't any problem initially when the form was stored with the SharePoint form library. However, when I published the form as a content type from Infopath 2007 and then added that content type to the form library, there are two columns for each piece of data from the form. (One from the content type and one from the form list.) I relinked each old form (list content type) to the new AbsenceRequest content type and removed the original one from the list. However, the duplicate column names are still there. Since they came from the Infopath form, they are not editable or deletable from the SharePoint list management interface. The duplicate column names make it tough to build views since it isn't apparent which column to use in the form building UI. It can be determined form the overview display, but it is very cumbersome.


Does anyone know a way to get rid of the old, absolute, columns?

Quick Note: Create Lists with Custom Content Types in SharePoint 2010

Learn how to create a list in SharePoint Server 2010 and associate it with a new content type. Next, you disassociate the list from the content type and then delete the list.

Field CLR Types via Lists Web Service

I have an app that is retrieving list data via the Lists web service.  Currently, all data is returned as a string in a DataTable.  This works ok, but it doesn't work with the charting tool, which needs values of type int or float.  So I set the column types based on http://msdn.microsoft.com/en-us/library/ms131092.aspx and http://msdn.microsoft.com/en-us/library/ms437580(v=office.12).aspx.  For example, if the field type is Number, then I set the DataColumn type to Double.  But now, certain values cause exceptions because the returned value doesn't parse to the documented type.  For example, Lookup type fields are documented to be stored as int types, but the actual values returned are like "1;#". Does anyone have some advice about how to do this?  I have a big switch statement that checks the field type, and sets the DataColumn type according to the documentation, and I'm thinking of reducing it so that it only sets some of the types, for instance, Number and DateTime, but leaves the rest as string types.my blog - Tea Time with Meowkins

New column to existing content types

HI, How can I add a new column to existing content type. The field shoule be reflected to new lists created using the content type as well to old lists created using the content type. None of functionalities associated with old lists should get affected. Thanks,kesari suresh

How to add a new column to a lists schema

Hi I want to add a new column in the schema of the calendar in sharepoint. So everytime a user creates a new calendar then he can automatically get that column to be filled. I know we can first create a list and save it as a template but my client doesn't want to see two calendars in the list type which will create a confusion. So i m looking for a way to add a yes no column the the existing schema of the default event content type.... Any Suggestions......Much Appreciated..

formula validation setting on column sharepoint 2010

Hi, Hi,  I have a two fields(mailid,cost,mailid2), i need a list validation of mailIds if already existing  mails three time I need a validation for new request , i need a formula for column in validation setting ->formula in SP2010  if mail is already existing validation  i need formula for validation setting for list it's new feature in sharepoint 2010 Regards

supported column types that can be used as additional fields with a Lookup column?

Can anyone tell me which types of columns can be used as additional fields for a Lookup column? Are they the same as the column types that can be used to create Lookup columns? Choice columns are currently not available (known issue) but I think they are officially supported. What about Managed Metadata columns? Thanks

ADO.net Setting value in column

Hi, I em trying the change the values of all numbers to o in a column calld  QuP in a  table called Segments with no possitive results. The same query works ok testing in SQL Dim sSql0 As String = "update Segments set QuP = 0" Dim oconn As SqlConnectionDim ocmd As SqlCommandtry  oconn = New SqlConnection(oseriDB.GetConnectionString)     ' the connection string is working right  ocmd = New SqlCommand(sSql0, oconn) oconn.Open() oconn.Close() oconn = nothingCatch ex As Exception lblmsg.Text = ex.MessageEnd try Thanks Dov

Content Types: Title Column Rename Issue


Hi All

i have created Custom Content Type.
Name: TestCP
Desc: Testcp
Select parent Content type from: List Content Types
Parent Content Type: Task
existing Group; Custom Centent Types.
Clicked Ok

-- Custom Content type successfully created. Now i clicked on Title column name and renamed To Action Title.
Radio button was seledted(Required(must Contain information))
Radio button was seledted(Update all content types inheriting from this type? Yes)

Clicked Ok.

it has remaned all the title columns of site collection.

Now when iam trying to rename it back its giving an error "The column name that you entered is already in use or reserved. Choose another name"

Please help me out to get it back.

thanks in Advance.

Add managed metadata column to list - access denied + terms not visible in lists


Firstly the following is not a problem for users given "Full Control" (and possibly other permission levels might work) at the web application level in central admin.

For any other user with permissions set at site collection level, even "site owners" (full control) , these problems arise.

  1. When adding managed metadata columns to a new document library list, clicking save results in multiple access denied errors getting logged (as seen using UlsViewer) and an exception is raised (sharepoint error page)
  2. In existing document library lists managed metadata column headings are displayed in list views but the terms text is not displayed.
This problem shows up even if the logged on user is the term set owner.  "Available for tagging" is enabled, submissions policy is closed.
Looking at http://<the-site-domain>/Lists/TaxonomyHiddenList/AllItems.aspx and then checking list permissions I can see that "All Authenticated Users" has Read permission level.
Integrated windows authentication - NTLM + Claims Based Authentication is the only authentication method used. It's an intranet site. 

Thanks in advance for any help.

Column Name - cannot convert between unicode & nonunicode string data types



Im using the OLEDB Source to connect the source columns. But its throwing an error msg Column Name - cannot convert between unicode & nonunicode string data types. Could you please provide me the oracle code so that I can use with the select statement. For some of the schemas I have chaged the data types using the derived column before the OLEDB destination.

Actually, one of my team member suggested me to use the Oracle char(2) in the select statement. Can any one help me with the code so that I can use it for the rest of the columns.

Eg source(External Column) - CreatedBYID - DT_wstr(18)

Source - Output cloumn - CreatedById - DTStr(18)



what are the List Types for lists in the IT Team Workspace template



What is the list type for the lists in the IT Team workspace?  I wanted to use a CQWP to retreive data but neither "Custom", "Tasks", "Project Tasks" nor "Issue Tracking" worked.

I created my own "Custom", "Tasks", "Project Tasks" and "Issue Tracking" within my IT Team Workspace and the CQWP drew that data (as I had it set to draw the type from the entire site).  So clearly there are no Customs, Tasks, Project Tasks and Issue Tracking types in the IT Team Workspace template.

Thanks for your advice.


PS reposted per advice from forum SharePoint 2010 - Using Visual Studio with SharePoint and other programming http://social.technet.microsoft.com/Forums/en-CA/sharepoint2010programming/thread/55951ded-2d90-4830-a692-d8e1d0b08f00

Designing lists: Quick key combination for adding a new list column field?


I'm simply looking for a way to quickly design lists, and I find it rather slow to use the mouse to go to the Add New Column button in the ribbon every time when I want to add a new list field.

The only column that can't be changed type of later seems to be the Calculated column. But for all others, you can still change them afterwards.

Content Type or Lists Lookup Column can't show additional fields which are Choice or lookup columns


I am trying to create some content types, but this also happens when creating new columns in a list.

Ok, here is my setup (which is the most basic way to replicate the issue):

List 1: Department List
Columns: Department Name (Single Line of Text)

List 2: Document Owners
Columns: Document Owner (single line of text), Department (Choice or Lookup from Department List), Email (single line of text), Lookup Field (Calculated).

Content Type: Quality Document
Columns: File Name, Title, Document Owners (Lookup from Document Owners List), Email (pulled in with Document Owner), Then i want to also pull in Department from the Document Owners list.

That is where my problem is.  When i select the Document Owners List as the list to get the information from, there isn't the option under "Add a column to show each of these additional fields" to pull in the Department column.  This occurs if i use a Choice in the Document Owners list, or if i do a lookup from the Department List.

My preferred method of implementing this system would be to have a multi-value lookup field in the Department List for Document Owners so that the Owners are attached to the Department, and if the owners change for the department they also change for the document that is for said department.  But, i run into the same issue that i c

Setting default parameters in dataset-populated pick lists


Visual Studio 2008 with R2 added. At this point I'm only using Preview (undeployed reports).

While I can easily set a parameter when the user has to supply a value for the report parameter, it is not at all clear how to set the defaults (and expect them to work) when setting the Available Values to be populated from a DataSet--with or without multiple values. I have seen the suggestion to use the pick-list dataset as a way to populate the default values list but this does not work.

I understand how to create a query that can accept "all" as an alternative input parameter to return all rows from the product, but shouldn't we be able to selectively choose from the list of valid parameter values by adding them as values in the list of defaults?


William Vaughn
Mentor, Consultant, Trainer, MVP

"Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)"

Please click the Ma

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend