Skip to main content

O365: Link a SharePoint List and a SharePoint Library

O365: Link a SharePoint List and a SharePoint Library

Data in a SharePoint on-line List can be accessed for Library Metadata

See also - Create a SharePoint library and Create a SharePoint List


This means that you can enter reusable data into a list and select it from a drop menu when entering data into another list or library.

In most business scenarios when an invoice is created it will be specific to a customer. If a customer is invoiced many times for different goods or services, it would be necessary to enter the customer details each time an invoice is created or imported into the document library. This chore can be avoided by entering the customer details once into the Customer list and having a drop selection menu to copy the data into the Invoices library.

The Method


If we use the newly created Customer list and Invoicing library as an example.
NB: Click the links for information on creating Libraries and Lists

  1. First we need to modify the Invoices library to add a lookup Select ‘Invoices’ from the quick access menu on the left, click the ‘Library’ tab.




  2. Click ‘Library Settings’ in the ribbon, then click ‘Create Column'



    Configure the column as shown above, then click ‘OK’ in the bottom right of the screen. This will enable selection of the customer details from the Customer list. However as the list already has a ‘Customer’ column the original must either be deleted or hidden. NOTE: In most cases it would be simpler to delete the Original ‘Customers’ column altogether. However, if the list has been in use for some time it may contain valuable data which must not be lost. In this case return to the Invoices Settings screen and double click the old ‘Customers’ column name. This is the original text column that requires manual entry of the customer details. It is set to require data entry

    Check the radio button ‘No’ for ‘Requires that the column contains data’ and click ‘OK at the bottom.

  3. Return to the ‘Invoice’ home page by clicking on ‘Invoice’ in the quick access menu on the left. Select the ‘Library’ tab and click ‘Modify View’. Uncheck the ‘Display’ tick-box for the Column ‘Customers’


    and the new columns will be displayed.

  4. When you import a new invoice document, or edit an existing one you will be able to select the customer from the Customer list via a drop menu.

Notes

  1. This assumes that the user has Internet access 
  2. Also that the user has been granted write access to the SharePoint site and library 
  3. If the library has ‘check in/check out’ enabled the user will be prompter to check on opening and check in on closing
  4. If the library has ‘Approval’ enabled the document will not be visible to other users until ‘Approval’ has been granted.


Need more help? - request a free call back 


Labels:

Comments

Post a Comment

Popular posts from this blog

Electronic Document Storage and Management (EDMS)

EDMS is not just a means of storing computer files. A full EDMS system allows for the process of importing both paper and computer generated documents into a computer system and indexing the files for easy and swift retrieval. In effect you can dispose of your traditional paper filing system. No more gathering letters, invoices and orders into filing groups and no more slotting them into the correct folders. Of course, you only use a paper filing system because you know you may need that document again in the future. Equally, when you do want that document it's invariably missing, either misfiled, or on someone else's desk. With EDMS documents are where you placed them and they are available for you to use where ever you are. All you need is a computer, tablet or smart phone and an Internet connection.As most modern businesses already use the Internet for everyday interaction with banks, Inland Revenue, Companies House, insurance companies, suppliers and customers it no longer
1 comment
Read more

Leadership: So you want to be Powerful?

Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions.     In a recent post on LinkedIn a n Influencer wrote that she had been asked the question ' Who is the most powerful person you ever met? '     The question was posed by a 17 year old and the author guessed that the answer being sought was the name of some sort of X-Factor figure, This strikes a cord with me. Throughout my life, in both business and personal spheres I have found that individuals seeking answers invariably look for 'silver bullet' solutions. This applies to all generations, 'Boomer, X-Gen and Millennial, it applies to individuals of all levels of intelligence, and to individuals at all levels of authority.     The desire for someo ne to appear, like a genie from a lamp, wit h either ' the answer' to a problem , or ' the power' to solve the problem, or
1 comment
Read more

Law and Order: The Anonymous Text Tip-Off

The following article came out of an interview conducted with Max Doleh - Law enforcement organisations and Crime Stopper programs are turning to technology which enables text tip-off from the public to facilitate a police response. In September 2007 Master Sergeant Charles Phillips of the Oklahoma City Police Department published an item on the Oklahoma City Crime Stoppers web site (http://www.okccrimetips.com/ ) calling for increased resources to bring this technology to OKC. In November 2007 it was announced that Crime Stoppers of Oklahoma City have engaged technology company ProductiveT to develop an SMS system that is radically different to others in use in the country. Max Doleh, ProductiveT president and CEO answers questions – 1 . What makes the Oklahoma City system so different? The ProductiveT technology differs greatly from other offerings. The police department have their own dedicated number for receiving the messages and unlike most systems there is no need for the sender
1 comment
Read more