.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

Add an auto incremental value to TITLE field.

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

Hi, i am currently working on a custom list in SharePoint 2010 and there is a title field. I would like to append an auto incremental variable to "Request" to make it look like:

Request 1

Request 2

Request 3



and so on...

As you can see below, i tried to use the calculated value Request+ID, but it didn't work out. So is there anyway to solve this problem?


<input name="ctl00$m$g_0bb0fcf5_65ea_4af9_ba76_7c0babad1a82$ctl00$ctl05$ctl00$ctl00$ctl00$ctl04$ctl00$ctl00$TextField" type="text" value="[Request-]&amp;[ID]" maxlength="50" id="ctl00_m_g_0bb0fcf5_65ea_4af9_ba76_7c0babad1a82_ctl00_ctl05_ctl00_ctl00_ctl00_ctl04_ctl00_ctl00_TextField" title="Title" class="ms-long ms-spellcheck-true" /><br />

View Complete Post

More Related Resource Links

SharePoint Batch Update Auto Increment Field Value


Hello All,

I am making use of SharePoint List Batch Updating methodology in order to update the items in bulk. I build the query dynamically for each and every item using StringBuilder and process the data ultimately using 'ProcessBatchData' Method.

Now, I have a requirement where I have to increment a particular field value in the query while iterating through each item for building the query. How can I auto-increment a field value for each item in the batch query?


Compare Validation for the Title field of the list

Hi, I do have a field known as 'Title' in the list.My requirement is there should be not be any duplicate values i.e first time if i enter say 'test' in Title field it should save where as second time when i enter same text as 'test' it should show message as 'item already exists with the Title that you have entered'.Ofcourse i should do the compare validation over here but just let me know how to do this Thanks & Regards, Sudheer

Auto-populating a field based on SharePoint Contacts List

Hello! Hopefully a quick question for you gurus :) So, I have two relevant fields in my InfoPath 2007 form: A drop-down list called Contact Name, and a text field called Contact Phone Number.  Contact Name is populated through a SharePoint Contacts List, retrieving their Full Name from that list. What I'd love to have happen is, when the user selects a name from the Contact Name list, have the form auto-populate the Contact Phone Number based on the phone number of the selected name from the SharePoint Contacts List. I tried to set a rule in Contact Name to, when the field is Not Blank, populate the Contact Phone Number with the phone number from the Contacts List, but all that does is populate the field with the top-most phone number, not the one matching the selected name. Any way to do this more accurately, and preferably without custom code? (Client has an explicit requirement to not have any custom code on the form or its associated workflow)   Thank you so much!

How can I remove/hide built-in Title field in list definition

Now I'm customize a new Content and then new List Template, just like below definition;  <ContentType ID="0x0100ed096ab35eeb4d2e98fb71b9842e9616" Name="Staff Member" Group="Berry Gardens Internet">  <FieldRefs>   <FieldRef ID="{fa564e0f-0c70-4ab9-b863-0177e6ddd247}" Name="Title" />   <FieldRef ID="{F5E777EA-C083-4c2f-BC10-E4BF2B4D6372}" Name="Synopsis" />   <FieldRef ID="{2307576C-A060-4c2d-BABC-34E5A9924667}" Name="Image" />   <FieldRef ID="{051B830A-8105-4384-9AA1-103CEE43B760}" Name="Email Address" />  </FieldRefs> </ContentType> It is inherit from Item parent type, and using built-in Title field({fa564e0f-0c70-4ab9-b863-0177e6ddd247}), but I found that it's diffcult to remove/hide it. When in the default list view, there are two Title fields. So what can I do in the list definition. Regards upzone    

Workflow - automatically create discussion item using title field of of custom list item as its subj

Anyone any ideas as to how I can configure SharePoint to create a discussion item using the title of a list item. e.g. user creates list item on a custom list - SP automatically creates a Discussion thread for this list item in the discussions list. I'm guessing this can't be down OOTB . would I be looking at SPD or a coded solution ? regards, Counie

Auto-fill Title and other fields from a data View edit menu

How do I Auto-fill Title and other fields in a list from a data View edit menu. The Title and other current data should transfer from the data view row being edit. Can anyone point me into the right direction how to accomplish this? Thanks. Mike  

Rich text editor for Title field in Publishing site


I have one French publishing site. I want to set one page title like this: see BOTOX trademark here . To show title like this i need to put tag like Product <sup>MC</sup> . Problem is, if i put above tags in title text box at the time of page creation then page title showing Product <sup>MC</sup> not  like above site.


Regards, Sandip Patil, .Net,Sharepoint Developer www.worldofsharepoint.com

When adding new calendar item the title field is missing - MOSS 2007



A staff member just noticed that when adding a new item to a vacation calendar we have set-up - the Title column is missing.  They will finish creating the new calendar item and then when they go to edit it the Title column appears and they can fill it in.

Can figure out what caused this or how to fix - any ideas?

When I create a new test calendar the title column is displayed properly when creating new item - so not sure what happened with this calendar.

Hope someone has come across this before.

Thanks so much!

Cross site lookup field value contains the parent list item id and the title field separated by ;# i

Actually we are using third party component for cross site lookup and facing the problem with cross site lookup field value. Its showing the correct value in default list view mode, but in "Edit in Datasheet" and "Export to Datasheet" view cross site lookup field value contains the parent list item id and the title field separated by ;#. I need the actual value in "Edit in Datasheet" and "Export to Datasheet" view as shown in default list value, i dont want that appended parent list item id and separated by ;#.

Is there any OutOfBox soluiton for this. Please suggest me for the same.


How to use Title field instaed of name field for a publishing page in the browser title bar


Hi All,

             I want to display the page title field in the browser title bar instead of page name field. Is there any way to achive this.




Problem with [ID] in TITLE Field.


On my TITLE column, I have set the default field as: "SPF-FW2010-&[ID]" ... however the error is that the [ID] is not being pulled from the existing [ID] field (that is the unique number that auto-increment). How can I go about solving this?

My desire output should be example:





... and so on.

Thanks in advance.

updating auto incremental sequence number in a column



can anybody tell me the quickest and perfect way to update the column with auto incremental sequence number without using cursor,while loop,temp table and using identity column, if possible in a single update statement.

I want output like







can this be possible in single update statement. Note that initially all the values in column col1 are either zero ar NULL



Sachin :)

How to change the display name for LinkTitle or Title field in a Custom List programatically


We have a requirement, where we need to create a list from "Custom List" Template, through a console application.
But we need to change the Display Name of the column named "Title" created by default to something else say "CategoryName". We do not want to remove the column but only change its display name, so that the column with name "CategoryName"still has a hyperlink and ECB menu attached to it..

The same can be done by going to list settings and changing the name of the Title column, but I am not able to figure out how to do it progrmatically.


"Title"].Title = "Some Other Name";
CustomListName.Fields["LinkTitle"].Title = "Some Other Name"

Auto-fill field with a dropdown list keep losing values



i have a question. i have created a form with 2 dropdown lists and 2 field. when the user choose a value in the dropdown list it auto fill the coresponding value in the field.

now i have notice when i'm busy creating the form and testing, when i preview the form i get this error:

Infopath can not open the selected form

and what i have noticed the dropdown list is not attached any more to the table i have set.

can someone tell me what the reason is that the field keep losing the attached field?

how to create an specific column and use it in many lists like "Title" field

In my sharepoint site I have lists that some fields are repeating in two list or more,to prevent of repeating I want to define one column or field and use it in any lists that I want, so I defined a column as an empty element and add it into my project,and in schema.xml file of my list .I add the

<FieldRef ID

how to create an specific column and use it in many lists like "Title" field

In my sharepoint2010 site I have lists that some fields are repeating in two list or more,to prevent of repeating I want to define one column or field and use it in any lists that I want, so I defined a column as an empty element and add it into my project,and in schema.xml file of my list .I add the

<FieldRef ID

How to Create Auto increment Request number for browser enable infopath form field Programmatically?

hi all,

i have created an infopath which have one request no. field and it will auto increment when click on add new item on sharepoint Document library

field contains (highest value of column request no. +1 )  when infopath will open in browser.

What i have done on this:i have create new data connection on sharepoint library and then pick document library then choose ID field and insert function in the field max(ID)+1.

help me


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