SharePoint 2007 Document Library : Autofield certain fields based on filename and folder container

Posted on 2012-09-10
Medium Priority
Last Modified: 2012-09-25

I have a user with that wish to automate the filling of certain fields in a document library. The document library has Year, Month, Company, Report Name columns and also contains folder with name of company.

User will upload multiple files into the document library with filename format YYYYMM_RptName into specific Company Name folders. She also wants the columns Year, Month, Company, Report Name to be filled based on the filename. So

YYYY goes into Year
MM goes into Month
RptName goes into Report Name
FolderName goes into Company

How can this be easiest done hopefully without any scripting.
Question by:NicksonKoh
  • 2

Accepted Solution

ezskol earned 1000 total points
ID: 38385621
Chances are you will need to use third party tools like RecordPoints.

Not sure if this will help you, but you can try to create the following columns:

Year Created
Column type - Calculated
Data type - Single line of text type  
Formula -

Month Created
Column type - Calculated
Data type - Single line of text type  
Formula -
= TEXT(MONTH(Created),"mmm")

Might be useful for you as it will autogenerated the years and month for you each time a document is uploaded.

LVL 17

Author Comment

ID: 38386223
Calculated Fields looks like the way to go!
But I want to base the formula on the Name field which is by default populated by the filename.
LVL 17

Author Closing Comment

ID: 38435153
Hi ezskol,

Calculated fields only solved half the problem it can only obtain values from other fields but not from folder.

I also played around calculated columns or normal columns with default values on the folders. It turn out that this can auto populate the fields of new records quite well as records created on the folder will use the defaulted values of the containing folder! So that solved the other 50% of the my problem without any 3rd party tools.

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month13 days, 16 hours left to enroll

809 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