asked on attach multiple documents to custom list. what's the best way?
I have a custom list containing information on technical drawings (name, part, author, date, revision, etc..) I also have files associated to each drawing sitting on my network server that I want to upload to sharepoint and link to their respective drawing. These documents are drawing comments (in word format, scans of the drawings (in pdf format), source files (in autocad format), Basically, I'd like an engineer who looks up a drawing in sharepoint to be able to easily pull up any of these relevant associated files with a simple from within sharepoint.
1) I know I could attach these files to each drawings, but is there a way have a separate column in my list for each attachment?
2) Would it be cleaner to create a document library for all these files and somewhat link my list of drawings to the respective document?
1) I know I could attach these files to each drawings, but is there a way have a separate column in my list for each attachment?
2) Would it be cleaner to create a document library for all these files and somewhat link my list of drawings to the respective document?
Microsoft SharePoint
Last Comment
odsail
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionASKER
thanks! I think I am going to put all the documents in a document library and create a field in my list that has multiple value and can lookup on this library ( I think asking users to enter a URL for the files is way too complicated)
however, how do I lookup the file NAME of a document and not the TITLE which can be anyhing and is not relevant for me.
however, how do I lookup the file NAME of a document and not the TITLE which can be anyhing and is not relevant for me.
SOLUTION
Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a questionSOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
chiche -
Have you had any luck with this? Let us know.
Scott
Have you had any luck with this? Let us know.
Scott
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Another thing to consider if you haven't already is, the order in which these items are created or added. If documents can be uploaded to a library before the custom list item can exist that can make it a bit tricky to link them in an automated way. If the custom list item must exist before the documents can be uploaded then you might consider creating a custom column that let's you create the folder in the library and captures that link and stores it in the column. Good luck! Let us know what you decide to do.
Regards,
Scott