Forum Discussion

admin fnetwork's avatar
admin fnetwork
Copper Contributor
Jul 02, 2018

[Question] Auto Incrementing serial number without Workflow

Hello,

I would like to create a calculated field column on a list in order to implement a custom ID for my projects. However, I cannot seem to be able to insert an auto incrementing number (ID column is not available for calculated values). I did a search and found some solutions using workflows, but I would prefer a solution without them. Can you help me?

Thank you.

6 Replies

Sort By
  • Anonymous's avatar
    Anonymous
    Jul 02, 2018

    admin fnetwork you can still use the calculated column for ID even thou it's not listed, just go into the formula field and do something like this ="TestID-"&[ID] and you'll get TestID-24 for example. 

    • admin fnetwork's avatar
      admin fnetwork
      Copper Contributor
      Jul 03, 2018
      I believe that in my case this does not work! it does not update the calculated column on new entries, and i have to edit the column for the id to be inserted.
      • jcgonzalezmartin's avatar
        jcgonzalezmartin
        MVP
        Jul 02, 2018
        If you don't want to use a Workflow or even some programming, I would recommend you to explore PowerApps possibilities

Resources