I have a list where the user can add new items. I would like to generate an ID based on who creates the item.
if Person A is the creator, then her ID="10000 + number of items she created". So her first item is 10000, the second is 10001, the third is 10002...
If person B create an item the ID is 20000 + number of items. I have 5 user in total.
Any method is fine. My plan is to create a list where I store how many items were created by each user and get information from it and update when new item is created. I think I should use workflows, but I don't have experience with them.
Thank you very much for any suggestion!