When a new item is created, i would like to auto populate a field that contains e.g. PRC245778
I have tried using a calculated field, based on the ID but this breaks when i add the next item e.g. ="PRC"& [ID]
I then tried doing a workflow, this works but then when i get redirected to the list of items, you can see that the required column needs updating. I have to refresh the page in order to see the incremented number and text. The workflow runs when an item is created.
Are there any other solutions. i have seen event receivers but i am not a strong coder so i am trying to avoid using this.