locked
Calculated Field Not Updating RRS feed

  • Question

  • Hello.

    I have a simple calculation in a SP2013 list that generates an ID number for a list item, very simple:- ="EMO"&ID.  This only works the first time you enter the code into the list or edit the code. When you enter a second item the formula doesn't show the ID.

    If you then edit the code in the list again it corrects any previous instances but wont work again.

    On the right of the Formula box in the Insert Column the ID field is Not listed amongst the available fields.

    Many thanks

    Jon 

    Monday, April 27, 2015 10:07 AM

Answers

  • Hi Jon,

    the ID internal field from SharePoint lists is not available for use in Calculated Fields.

    You have to use a workaround... have a look at this link:

    http://www.spankh.com/archives/121

    You should use a workflow for what you want.

    And this: 

    http://spandps.com/2011/03/09/unique-alphanumeric-list-ids-via-spd-workflow-and-calculated-columns-sharepoint-sp2010-in/

    Best regards.


    Monday, April 27, 2015 11:00 AM
  • Hi,

    Please refer to the following blog

    http://sharepoint.stackexchange.com/questions/22977/how-to-use-calculated-field-to-retrieve-the-id-of-the-item-in-the-sharepoint-200

    The following are the steps in the workflow

    • Create a workflow variable to capture the ID
    • Set <<workflow variable>> to {Set Field in Current Item} ID
    • Append text such as "EMO" to your workflow variable.
    • Finally update your custom field with the workflow variable.

    Please don't forget to mark it as answered, if your problem resolved or helpful.

    Monday, April 27, 2015 11:07 AM
  • Hi

    ID can't be used in calculated column, Only in workflow, eventreceiver, or also usin javascript in editform.aspx ( not in newform.aspx )

    But i recommend you to use Document ID feature

    http://www.c-sharpcorner.com/UploadFile/40e97e/document-id-service-in-sharepoint-2013/


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Monday, April 27, 2015 12:08 PM

All replies

  • Hi Jon,

    the ID internal field from SharePoint lists is not available for use in Calculated Fields.

    You have to use a workaround... have a look at this link:

    http://www.spankh.com/archives/121

    You should use a workflow for what you want.

    And this: 

    http://spandps.com/2011/03/09/unique-alphanumeric-list-ids-via-spd-workflow-and-calculated-columns-sharepoint-sp2010-in/

    Best regards.


    Monday, April 27, 2015 11:00 AM
  • Hi,

    Please refer to the following blog

    http://sharepoint.stackexchange.com/questions/22977/how-to-use-calculated-field-to-retrieve-the-id-of-the-item-in-the-sharepoint-200

    The following are the steps in the workflow

    • Create a workflow variable to capture the ID
    • Set <<workflow variable>> to {Set Field in Current Item} ID
    • Append text such as "EMO" to your workflow variable.
    • Finally update your custom field with the workflow variable.

    Please don't forget to mark it as answered, if your problem resolved or helpful.

    Monday, April 27, 2015 11:07 AM
  • Hi

    ID can't be used in calculated column, Only in workflow, eventreceiver, or also usin javascript in editform.aspx ( not in newform.aspx )

    But i recommend you to use Document ID feature

    http://www.c-sharpcorner.com/UploadFile/40e97e/document-id-service-in-sharepoint-2013/


    Romeo Donca, Orange Romania (MCSE, MCITP, CCNA) Please Mark As Answer if my post solves your problem or Vote As Helpful if the post has been helpful for you.

    Monday, April 27, 2015 12:08 PM