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

Acquiring Market Share. MD, MD, how does your business grow?

Gaining an increase in market share may become necessary for a number of reasons. You may need to shift focus from one product line to another in the face of a declining market, you may wish to expand to fend off a market place squeeze or you may just be growing towards your planned capacity. Whatever the reason, you will need to form an acquisition strategy. There are three ways to obtain an increase in market share – Earn it. Use competitive trading to buy it. Acquire a competitor. Each of the three approaches bring along its own strategy requirements and its own issues. Selecting the best approach depends entirely on circumstance. Outperform the competition. Earning market share by supplying a better product, better service, better support, better delivery is an honorable way of expanding a customer base. It is steady, progressive and undemanding in that production/purchasing is not subject to stresses caused by sudden up-shifts in supply/delivery. Even so, there are issues. Attaini...
Post a Comment
Read more

The New Computer Age: Office 365 Vs Google, Dropbox and Others

Differences in Software as a Service ( SaaS ) This is the 21st century, the New Computer Age. Cloud services and SaaS are available for all to use. Word on-line, Excel on-line and Power Point on-line are just such services. They are available to all who want them, they are free, if taken via One Drive Live, and they enable the creation, editing and viewing of Word documents, Excel spreadsheets and PP presentations on ANY device that has a browser installed. This without any need to install software on the device used. The on-line software that is used to create the files is the same on-line software used to view them. There can be no incompatibilities and no missing fonts. Open Document Standards, to which these most office applications conform, requires that any document file should contain the properties of style, layout, font etc. These elements are the property of the document file and will travel with it wherever it is stored or sent. However, issues can still aris...
Post a Comment
Read more

O365: Mobile Apps - the easy way

 O365: Mobile Apps - the easy way See also -  Other Office 365 Posts Anyone following these posts will now know how easy it is to create data stores in SharePoint for documents and files and for listing data, such as customer details. We've also looked at making this data easily findable, how to flag items for the attention of individuals and teams within the Office 365domain and moving work through the system in a controlled manner. We've also seen how we can access this content when away from the office via mobile apps for Teams, SharePoint and OneDrive. Occasionally the standard apps aren't really convenient and fail to lend themselves to mobile use. I'm thinking here of functions like stock lists, customer contact lists and the like, when the standard app delivers too much detail for a small screen, or where links and buttons are small and difficult to use. For these functions it would be better to deploy an app that is designed for fast, effective use on a mobile. ...
Post a Comment
Read more