.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

Dynamic list item title based on date created & regional settings?

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :SharePoint
I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

View Complete Post

More Related Resource Links

No title displayed in the "New" item creationfor a list based on a created list template.


Hello everybody,

I have a problem with a sharepoint list template. I created a custom list in MOSS2007 that I saved as template. The problem is that the new list based on that saved template doens't display the Title (changed on project's name) when I want to create a new item. So after creating new items, their Project's Name (Title) is set to (none) for all of them because I couldn't specify any Project's Name (Title).

I was back to my original list and when I create a new item, the Project's Name is displayed so I can fill it. I searched in the list settings and nothing was special.

The columns are required in both lists, there is no management of content types (maybe a hidden field but NO!), the list is a typical list with basic settings.

Has someone an idea?

I want to reuse this list and the Project's Name (Title) is very important (!).


Thank you.

Updating a List item field value in a SPD Workflow is setting Date fields to null

Hello everybody,I faced a very weird behavior while creating a workflow in SPD against a Document Library.Here is the case:1- Create a document library in sharepoint site.2- Add a custom column of type DATE.3- Upload any document to the library4- Edit the item metadata and set the custom date field to any date you want.5- Now using sharepoint designer, create a very simple Workflow with only one action that updates the current item "Title" field to any value. (Note: In my case I set the workflow to start manually and not automatically)6- Save the workflow and then start it on the uploaded item.7- Now check the value of the date column after the workflow is finished.8- You will see that the Date field is Empty... (very weird)Notes:   1-This behavior will not appear on a standard list. it is only appearing in a Document library.  2- I am using WSS 3.0 SP2 + MOSS 2007 SP2. Also SharePoint designer 2007 SP2Did anyone face this situation and does it have a fix, or am I doing something wrong here... Please help.Regards,Maheed

ListItem Dynamic DropDownList based on custom list entries.

I utilized the following solution to get the drop down list on the page and populate it dynamically, but it doesn't save the selected value back to the SPListItem object. Does anyone have a better solution possibly for this? http://geekswithblogs.net/SoYouKnow/archive/2010/01/21/sharepoint-populating-drop-down-list-field-with-data-from-different.aspx

Updating a list item based on the value of a different list item

Ok, I've searched everywhere and have gotten mixed information about whether this is possible with standard Sharepoint functions.  I new at Sharepoint, but I'm doing this to help out the department which is short of help right now.  Here's what I'm intending to do - We need a small ticketing system to track software requests.  I created a basic list that accomplishes this fine.  I created another list with criteria that software must meet in order to be approved called software evaluations.  I made a "choice" column called approval status in both lists that have the following options: Approved, Pending, Rejected.  I'd like the softwarerequests.approvalstatus to mirror whatever the softwareevaluations.approvalstatus column value is.  I created a workflow using SPD and it's seemingly easy to use.  I attached it to the softwarevaluations list and set the following as the matching criteria: if softwareevaluations.approvalstatus = "approved" then softwarerequests.approvalstatus = "approved". It mentions that the values aren't unique, but I accept anyway.  It doesn't do anything and I'm thinking it might be because it doesn't know what "issue" to reference.    I feel I'm all over the place right now, so it might be easier if someone just asks me what you need to know to help.

Updating an item in one list based on data from another

I thought I understood this fairly well, but it seems that I am missing something.  I have created a change management site that uses a calendar list to mark upcoming changes to our IT systems.  I have also created a second list to track some information about the change items that I don't want to show up on the calendar, such as what the outcome of the change was or if the change process was properly followed.  So I have the calendar list and another list called results.  I know that there needs to be a unique identifier that each list item will have in common, so in the results list I created a column called Change Number.  When a new change item is created in the Change Management calendar a workflow runs that notifies some people that a new change has been submitted, and the last step in that workflow creates a new list item in the results list and sets the Change Number field to be equal to the current item ID field.  That part is working right now.  When I create a new change item I can open the results list and see that there is a new item and it has the proper number in the Change Number field. What isn't working is when I try to take actions in other workflows that use data from both lists.  An example is notifying the creator of the change that it has been approved.  When the list item is changed a workflow starts that

How do you filter a list in a Meeting workspace based on the meeting date?

I have a customer who is using a meeting workspace, and has a list on said workspace (we'll call it "Meeting Instance List"). The workspace houses this list, and of course after each meeting, the workspace, in essence, resets itself in preparation for the next meeting - so it looks like it removes the items from the list, when in actuality, they are there, just on the previous meeting instances. Some of his stakeholders are finding this limiting because they perceive it as losing historical information (you know how some folks can be, if they don't see it, they think it's gone). His solution is to replace the non-series list, with a series list, and incorporate legacy records from another older list. Only problem is, now there's not a way to filter the series list so that it shows items from a parcticular meeting date. For instance - the [Today] variable will only return a current system date value. Surely there ought to be a similar variable that would all you to filter the list based on meeting date, right?

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

Edit item title in a list on a mobile page

hello, can i edit an item title for a list on a mobile page in MOSS 2010 ? e.g i want my list items to appear as "New task StartDate:current EndDate:current" that includes three things the list title,startdate and enddate for the item. thanks

How to remove 'Delete Item' from context menu of a programmatically created list?

How to remove 'Delete Item' from context menu of a programmatically created list?
I have document library which is created programmatically but now I don't want to have 'Delete Item' in context menu of that document library. Are there any possibilites?

How to copy a Column data from one List to another list whenever a new item created .


Hello ,


I have List A and List B

List A


Ticket ID

Column A

Column B

Column C


List B


Ticket ID

Column 1

Column 2

Column 3

I want to copy only Ticket ID from List A to List B , whenever a new item created in List A.

can you please give your thoughts?

how to do it?

Thanks in Advance!


Share Knowledge and Spread Love!

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 Create Sharepoint Workflow (designer) on Calender List when a new list item is created



I need to create a sharepoint designer workflow on Calender List.The functionality is that, Workflow on Calendar list that sends an e-mail notification each time new event is created along with event details.

Any help appriciated..



Srikanth Reddy


How to perform actions right after new list item was created?



I've created custom attachment field, so this field collecting file names from user when user creates new list item. Well, i got local file names list, i know how to upload them to library, but i need to upload them right after list item was created ( i need to assign uploaded files to this new item by its ID ). Something like item attachments works, files uploads after ( or durnig - not sure ) new item created.

btw, i cant use workflows because files are at client side.

Any ideas?


How to be emailed about Scheduled end date on a document list item

I have configured a sharepoint document library to allow users to use scheduling and so it can be published and un-published on a given date. I need users to be able to set an alert to be informed about when scheduled end dates are reached. I tried using the out of the box alerts but this does not seem to be triggered. Can anyone suggest the best approach?

Need help with filtering a list based on Date and Time




We are implementing a SharePoint list for our resources to provide information as to whether they will be in the office that day, working from home, etc..


All entries are supposed to be in by 8:30 am and a report is created at that time; however, there are always a few stragglers. 


I would like to create a

Create a link to the most recently created item in a list.


Hi all,

I have a list, that a user must re-visit several times a day.

I have a web-part page that contains a series of URL links to the above list (each link is clicked on at a different time of the day).

The idea is that the first link takes the user to NewForm.aspx to create a new list item for that day, but I then want the other links that they click on later in the day to take the user to the SAME list item they created earlier.

i.e. EditForm.aspx?ID="the one they created at the start of the day".

How can this be acheived? Do I need to determine the last item in the list (which would always be the one they need to re-visit)? Do I create some kind of workflow that stores the date and time stamp and then is called in the URL as a parameter when passed to the EditForm.aspx page?

The user would be the only one working on this list during any given day, so there's no danger of a different user "intercepting" a list item first.

Thanks in advance!


Regional settings (locale) in SP - is there any way to change that settings? eg. date format

The system I use is MOSS2007. I have regional settings set to "Polish". The default date format is yyyy-mm-dd, what is wrong because usually is dd-mm-yyyy. Is there any way to change specific regional settings? I couldn't have found it on internet. I've tried to change to "French", which gives me dd-mm-yyyy, but then eg. in calendar I have days and months in French language :)
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