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


Post New Web Links

Static or Constant List Columns

Posted By:      Posted Date: October 22, 2010    Points: 0   Category :SharePoint
 

I am a SharePoint newbie and I am creating an Issue Tracking list that will be used as a template.  I have three columns that will be static for each project.  The project number, project name, project manager.  The only solution I have come up with is each time a new list is created from the template to set the defaults for each of these columns to the appropriate text.  To reduce redundancy, I would then create webpart that will show a single distinct instance of each column.  Is there a better alternative?




View Complete Post


More Related Resource Links

Required columns on list; how can I reset them to be NOT required?

  
I have a user list where several fields in a sharepoint list that were originally created as required, but would now like to make them not required. I have already tried simply unchecking the required field checkbox, but that does not work. Any other ways to do this?

Trying to move FK links from list as columns to my navigation area.

  

Hello,

I'm using vs2010, EF. I have a left column simular to a navigation area and I'm trying to figure out a way to display the FK links that appear at the end of a list as columns, in my navigation area.  One thought was to place a duplicate table in the navigation area and hide all the columns except for the FK links. Is there an easier way to accomplish this.

Thanks, Jeff

 


Creating List Definitions with Custom List Columns for SharePoint Server 2007

  
Learn to use Visual Studio 2008 Extensions for Windows SharePoint Services to create a SharePoint list definition that implements custom list columns.

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns become read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug?

Query Sharepoint list, rich text columns returning HTML tags

  
Hi! So I have an issue that maybe someone of you have encountered as well. I am querying a Sharepoint list and creating a report from the data collected from this list. This all works fine except that one of the columns in this list is of the type "Multiple lines of text" and also supports "rich text" with different fonts, sizes and so on. This has the effect that the text returned from this column is wrapped in HTML tags that specifies how the text should be formatted. Naturally I do not want this HTML code to appear in my report so for now I have used custom code to do a string.replace and replaced for example <div></div> and <br> with "". However, this column also has url references to documents and these links shows up like this "/servername/site/subsite/Gemensamma%20dokument/Mwh.docx">http://servername/site/subsite/Gemensamma%20dokument/Mwh.docx There is some sort of double reference to the document that I guess like the HTML tags are embedded in the answer from the rich text column and this is not so easy to do a string replace on because the url varies with the different document and document names. My question really is if anyone of you have done a similar report that I am doing, and have encountered this fenomen with this sharepoint column and how you did to solve this? I have tried to creat

Reorder List Header Columns Issue

  
Hello to all, Today my senior told me to add functionality of Drag N Drop inside the GridView then i googled it and i found that Reorder List is the Same control i am looking for. But after doing Analysis on that i found that these templates are there in ReOrder List Control DragHandleTemplate EditItemTemplate EmptyListTemplate InsertItemTemplate ItemTemplate ReorderTemplate Its same as gridview or listview control but its dosent support paging in that.But i am not able to found Header Template inside that Control.   So Can any 1 Tell me how can i add header Template inside ReOrder List so Each Column will have its Rows. My sample example 1 Column is Eating all my columns and the rest of the columns are blank. I am looking any solution for this.   Waiting for a Solution   Regards    

Can Managed Metadata columns be edited in the DataSheet View of a Library or List?

  
Hi, I like to mass set document properties in a library using DataSheet View, the properties are columns based on Managed MetaData values. When I open the doc library in Datasheet view, those columns are read-only. I made sure the library does not require 'Check Out' and also tested it in other views then the AllItems view. Can someone confirm what is the expected functionality and or if there is a bug? Should I be able to edit them in 2010 and were they editable in 2007 version. Please help. thanks. I came across this other post which suggests that functionality is not available ? pls someone confirm. Mass-editing metadata when documents are uploaded (individually or in bulk) to MOSS 2010  

Read only view to certain columns in a list

  
Hi, I am using SP 2010 and needed help in customizing an exisiting list. I need to make 3 columns of the list editable to 3 users only and the rest of the users have a READ-ONLY option. How can this be done?

make columns read only in a list

  
Hi, I am using SP 2010 and needed help in customizing an exisiting list. I need to make 3 columns of the list editable to 3 users only and the rest of the users have a READ-ONLY option. How can this be done?

Name Column Not Included in List Columns

  
I created a custom content type derived from the Folder content type.  The “Name” column is included in the custom content type columns.  I add the custom content type to a custom list that allows multiple content types and the "Name" column from the custom content type is not included in the list columns.  Normally, the custom content type columns are added to the list columns, but for some reason it works differently for the “Name” column.  Even though the “Name” column is not a typical site column and not included, it’s a problem for me because I need it for a SharePoint/SQL Server data flow task. The data flow task is using the SharePoint list source and destination components and I need to map a database column to the “Name” column and it must be specified in the list columns.  Does the “File” type for the “Name” column make it impossible to be included in the list columns?  Any help is appreciated.

Lookup columns in a SharePoint Custom list

  
Hi, I would like to know the maximum lookup columns we can create in a SharePoint Custom list. Thanks and regards, Usha   

colour columns in a list

  
hi, is there a way to colour columns in a list, there is no criteria..I just need column 1 - 5 to be coloured with one colour, column 6 - 7 with another..    

OLEDB/ADO Destionation - Add input column twice to destination columns or static data

  

(Using BIDS 2008 R2)

OLEDB/ADO Destionation

Reuse input column
Is there any way to map a input column to two destination columns?

State static value instead of mapping column
I have a package for each version of the production system - they insert in the same destination tables - I just need to add a version number to the version column - like '2.1' and '3.0'. The only way I have found so far is to select a fake column in the source like select '2.2' as Version, ..- This is however not very smart when I'm selecting millions of rows.

I would just like to be able to type in a static value instead of mapping a column - any way to do this?


Duplicate Fields during list creation from content types and site columns

  

I am trying to create a List in Sharepoint 2010 using Site Columns and Content Types. It results in creating duplicate fields in the list for the Site Columns used. Here is the details description of what I was doing.

I have created two site columns 

 

<Field Type="Number" DisplayName="Start Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{A3F2D108-11B5-4B49-9633-338D27227E12}"
Name="StartCoordinate" Overwrite="TRUE" />

<Field Type="Number" DisplayName="End Coordinate" Required="TRUE" EnforceUniqueValues="FALSE" Indexed="FALSE"
Group="QMS" ID="{06B927BB-C354-4A0A-AE88-9C14E55EAB27}"
Name="EndCoordinate" Overwrite="TRUE" />

Then added these to a new content type I

Columns of E-Mail Enabled List

  

Hi everyone,

hopefully someone can help me with this MOSS-Issue:

when you activate incoming e-mails for a document library, sharepoint automatically creates a few columns in the document library such as "e-mail to", "e-mail subject", etc.

The problem is that it seems not be possible to access a few of these newly created columns.

In my case i have to create one list where the user should be able to send and also drop e-mails to while using the same columns for the emails metadata (to,from. email datetime). When i drop e-mails to the list, it doesn't care which 3rd party tool/outlook add-in i use - they are all not able to access the newly created columns to save the email metadata into.

So is there a way to change the columns used for incoming emails in a document library ?

Tim


Change order of columns in a list

  

Hi there

I'm looking for a way to change the order of the colums in a list in SharePoint 2010. I only have access to SharePoint Designer 2010 for editing the site.

I already looked at the function to create custom views for lists. However this are only useful when viewing the list as a whole, however when you edit an existing, or create a new entry you will see

  • first: the columns in the order in which they were created.
  • and second: all of the columns. i cant find a way to make certain columns invisible for the user.
I already looked through the functions that are given to me by SharePoint Designer 2010 when editing the columns of a list and I also checked for a way to change the order of the columns when surfing the actual website with Internet Explorer.

Does anyone know how to do this? Or am I just trying to find a function that doesn't make sense because it's covered by another feature?

Thanks for your help!


Getting list of tables with Identity Columns

  

Hi,

I'm new to SQL Server, could somebody help me with the query for

Getting the list of tables with indentity columns i.e to check the key info in the system tables along with column data types.

Thanks in Advance

KiranBabu


Categories: 
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