Auto-populate columns based on data of other columns (SharePoint2013)

Hello, 

I need a very simple solution to auto-populate column based on data of other column. 

I have a specific column that called Client Name. This column is created based on the choice menu with names of the clients. 

Example: Microsoft, Bell, Asus, Blackberry ect...

When adding a document (or any content type: folder, document ect) a choice should be made with company's name that reflecting this type of document. 

But inside the system we having also special ID's for each company. 

Example:

Client Name: Microsoft - Client ID=100

Client Name: Bell - Client ID=101

Client Name: Asus - Client ID=102

Client Name: Blackberry - Client ID=103

Presently, when adding a document (or content type), we having two columns to choose from: 1. For client name choice 2. For client ID choice. 

Those two column are connected with logic one to another. 

My question is:

1. How can I create an auto-populated column that when I will choose Client Name the system will automatically recognize its predefined ID for this specific clients name. 

Thank you.


  • Edited by 1Qwer 1 hour 17 minutes ago
May 17th, 2015 2:21am

You should explore "calculated" columns in SharePoint, you might be able to pull off your scenario. See: https://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx?f=255&MSPPError=-2147217396

Alternatively, a workflow and a lookup column can do the trick. This link has some similiar stuff: http://sharepoint.stackexchange.com/questions/108544/workflow-condition-using-a-lookup-column

HTH!

Free Windows Admin Tool Kit Click here and download it now
May 17th, 2015 2:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics