I've a drop down consisting the names of different banks for ex. HDFC, AXIS , ICICI etc. How to generate unique Id for eace branch suppose for HDFC is selected then the unique Id will be HDFC0000, HDFC0001, HDFC0002 and so on for AXIS it will be AXIS0000, AXIS0001 etc ?
- You should create two lists.
X list for different banks and Y list for its branches.
Lookup the bank name column from X list into Y list.
Create items for all the different branches in Y list.
Create a calculated column in Y list for e.g. BankId (column name) and use the below formula to concat bank name and Id