SharePoint List Question for the Gurus. Dynamic Date Column from reading title of another column that has DDMMYY ?

Posted on 2011-10-23
Medium Priority
Last Modified: 2012-05-12
Hello Experts.

I have a column that shows the titles of uploaded documents.
For example the document  titles are respectively called  BBP 102211 Friday .doc. ( where the date is DDMMYY )

I have another column ,a list item using the matching date of the document on the same row.
In this instance I would have to enter October 21 , 2011.

Is there a way to have the date read of the aforementioned document title and dynamically populate the date list item?

The purpose:

I have a library where I have the non techies upload their daily documents.
On a separate page I have a web part that displays the current document from that library for the day.
I can't filter by created date because they don't always upload/ create them in succession.
I can't use modified date because they sometimes re-modify them.

They are not computer literate and to teach them how to fill the date list item ( column ) which I use to filter the current file ,would make them all nervous and crazy!

Your expertise is greatly appreciated.

Thanks in advance.
Question by:colonelblue
  • 2
  • 2
LVL 18

Accepted Solution

ivan_vagunin earned 1500 total points
ID: 37016846
Hi! What is the type of the field to want to write date to (DateTime/Text)?
I see several options here:
1) You can try to do it with calculated field, but I'm not sure if you can parse do title with standard functions (http://msdn.microsoft.com/en-us/library/bb862071(v=office.12).aspx) - this is the simplest way because does not require custom coding
2) You can create an ItemAdding event handler for the list (http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spitemeventreceiver.itemadding.aspx) and populated the field with the value based on doc title inside this handler - this will require custom coding
3) You can create custom field type and custom field user control, that will populate the field with the value, based on doc title - this is the most difficult, and probably will work with standard list form only.

So, I would advise - to use second option - it is flexible and quite easy to implement. If you need any additional info on this - please ask.

Author Comment

ID: 37018902
Hello  ivan, it s a Date and Time field, and I chose Date Only.

Wow all the info you gave me seems complicated. I am not a coder.
How would I implement what I needed to make the Date and Time field be dynamically filled out from reading the date on the document title name?

Thanks in advance.
LVL 18

Expert Comment

ID: 37020041
I'm afraid you cannot do that without custom coding (at least I don't know how). Can you use Visual Studio 2010 to create a feature with event handler? If yes, I can provide code for the handler.

Author Comment

ID: 37032348
:( Sorry to say I am not much of a coder nor familiar with Visual Studio,

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question