1

I am trying to create a unique identifier using a combination of a few letters and numbers, for example: abc1000, abc1001, abc1002. The text will always be the same and the number is based upon the item's ID plus 1000.

The current code that I have in my calculated column is as follows:

="abc"&([ID]+1000)

Which works perfectly fine except that for new items, it seems that the calculated column is generated before the "ID" column if that is possible. Therefore, all of my "unique" identifiers come out to be abc1000 since it thinks that my ID value is 0.

Is there a way for me to generate the ID before the calculated column or can I update the calculated column after the fact in a workflow somewhere?

Thank you!

Improve this question
1
  • Create a column and set its value in designer workflow. Set column parameters as ShowinNewForm, ShowInEditForm as false.
    – Deepmala
    Apr 18, 2018 at 17:44

1 Answer 1

Reset to default
1

Correct. And there is no OOTB work around. ID column won't work.

You'll need a workflow to update the field. Something simple as Edit right after it has been created.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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