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.
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.
- Edited by 1Qwer 1 hour 17 minutes ago