I have a request from my employer for a SharePoint Solution that is likely outside of the box of what I can do as an Administrator. I’m guessing we need a developer to accomplish this, which unfortunately isn’t likely to happen due to funding and the fact that our projects are coming to a close.
In any case, thought I’d pose the scenario here and see if perhaps anyone has some ideas.
What I’ve been asked to do is to build upon an existing SharePoint list of projects. In this list, we want to add additional columns. The purpose of these columns is to indicate the presence, based on date, of a particular document in a SharePoint document library. For example, for Project “A:, we want to indicated in a specific row for that project under the column entitled “Document 1” whether a document with a similar naming convention as the project name in the list exists in the document library, and if it does exist, the date the document was last updatedposted to the document library is displayed in the column for that particular project.
Seems to me in order to make this happen, there needs to be some behind the scenes logic that continuously monitors the document library in question for a particular column, and parses all the file-names in the document library, inserting dates into the columnrow where it finds related documents. If no documents are found, then that particular columnrow will not be populated with any date information.
Bonus function would be to have the date displayed be hyperlinked to the actual document in the document library.
Truly grateful for any feedback and thoughts anyone has in this regard.
Best Regards,
ChrisÂ
Hi, tech101.
To add into the workflow that can be written using SharePoint Designer or Flow.Â
You may want to add a lookup column from your Projects list so that you can identify which list item to update rather than relying on filename following a naming convention.Â
Fred
You could achieve this by attaching a workflow to the document library & have a reference to the project list in teh library. So whenever a new document is added/updated, you could refer to the relevant project in the projects list and update the date column. As you said you can do a custom development too, using an event handler but workflows is the simplest way i see.Â
And for the hyperlink part of it, you may need to insert the date as a html anchor field, which you need to convert it to a link using a javascript on a page. For this yes, you need a developer.
