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 ?

  1. You should create two lists.
  2. X list for different banks and Y list for its branches.

  3. Lookup the bank name column from X list into Y list.

  4. Create items for all the different branches in Y list.

  5. Create a calculated column in Y list for e.g. BankId (column name) and use the below formula to concat bank name and Id


| improve this answer | |

If you are wanting to automatically create a new ID as each branch is added, you will need to use a workflow.

If you want a unique ID, but it does not need to start with 1 for each bank, then build a calculated column using the Bank from the choice list and the list item's ID property.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.