2

One of our employees wants to have a column in his list that autoincrement from 100,000. I tried to use "ID" column, then create a "calculated" column that adds 100,000. That didn't help; id populates after item is generated. Then I found an article telling me to use sharepoint workflow. But I can't seem to find where it is. The article also suggests to use Sharepoint Designer, but that thing hasn't been upgraded since 2013.

Does anyone know how to generate a column like this?

4

We can achieve this using the SharePoint designer workflow.

Here are the steps to create an auto-incrementing number field in a SharePoint list designer workflow:

  1. Create a new column, such as : Increment Number in issue list with Number type. Make this column hidden in a view.
  2. Create another column, such as : Issue No. in issue list with Formula type and add the following formula = “100000” & [Increment Number]. This Column will show the increment items’ numbers in the list.
  3. Open SharePoint designer, create new list workflow (for issues list).
  4. Add a workflow action: “Update list Item” >> Current Item >> Add >> Set this field to your Target field (Increment Number), set value from Current Item:ID field.
  5. Set the workflow start option to “Start Workflow automatically when an item is created”.
  6. Save and Publish the workflow.

For detailed steps refer the below:

How to Create an Auto-Incrementing Number Field in a SharePoint List

Auto Serial Number in SharePoint New Form

| improve this answer | |
  • It did work, but the list requires a page refresh to see the changed value. Is that correct? – Duk Dec 19 '19 at 22:51
  • Ohh.. I think in that case, we can redirect to same item URL after updating the field using the Redirect URL action in the same workflow... that will solve the issue. – GSD - SharePoint Dec 20 '19 at 8:39
  • Actually I was wrong. It does update automatically. No refresh required. But it's not instant sometimes. – Duk Jan 7 at 18:48
  • Thanks for keeping the community updated :-) – GSD - SharePoint Jan 7 at 18:55

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.