sharepoint - ID Field doesn't automatically update -


I have a field that uses the calculated column type to reference the ID field. It's basically: name and id like name 01, name 0, name 03 etc.

However, when I add new lines to SharePoint, this column is not updated automatically and I have to manually click in the field to update it.

Is there any way around this? Thank you

I have also seen this behavior, and this is not clear because when you first make the column (And every time you edit the column) everything is fine and fastened.

I have found that I can get this problem using a SharePoint Designer workflow. A simple text field updates the workflow ID value to store the values, and then the calculated columns can reference that text field instead of the actual ID field.

Step:

  1. Item IDID in my list
  2. Add a text field, in SharePoint Designer, add a new workflow to the list and add it
  3. Add a workflow action to store the item's id in the string (create dynamic string)
  4. Add a workflow action to set itemID field
  5. Add workflow action to update existing items (update list items)

    Then I just have to render the values ​​saved in the previous step [IDID] instead of [ID] in my calculated column and it works like a magic

    One downside is that users will stop seeing the item IDID field on new and editing forms until you do something to hide it.

    If you have more time on your hands and want to avoid the workflow history spamming, you can do this event in event handler.

Comments