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.