Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Question
Monday, September 24, 2012 12:22 PM | 1 vote
I have a calculate column in a shrepoint list:
=ID&" "&Title
But I see that when an item is openend the calculation is not done and the ID and Title is only the Title...
Mike
All replies (15)
Tuesday, September 25, 2012 1:47 PM ✅Answered | 1 vote
Hi
ID value is replaced only after the item is created. To use ID's value, use workflow with propper formulas
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.
Tuesday, September 25, 2012 2:50 PM ✅Answered
Useing ID in the calculated columns is not good option because ID will created after item added successfully in the list.
Better to go for a simple SharePoint designer workflow and concatenate as per requirement.
Hope this will help you.
Senthilrajan Kaliyaperumal
Monday, September 24, 2012 12:40 PM
Hi mike,
Use this
=[ID]&" "&[Title]
For more info on Calculated Columns visit this link
http://msdn.microsoft.com/en-us/library/bb862071.aspx
Tuesday, September 25, 2012 7:02 AM
Please see my answer on this SPSE question regarding the [ID] field in calculated columns:
http://sharepoint.stackexchange.com/a/46258/1529
Tuesday, September 25, 2012 10:13 AM
That's an interesting idea. You could even use an Event Receiver to populate it using the ItemAdded event.
Tuesday, September 25, 2012 12:21 PM
hi. I have only Sharepoint Foundation so some of these remarks are not feasible. I still do not understand why an existing ID is lost when I edit the item. I do understand that when a new one is created the number is not yet there.. but an existing...?
Mike
Tuesday, September 25, 2012 12:32 PM
It seems the same code is used for editing and adding items; which doesn't use the ID field at all.
The fact that the formula add/edit code does use the ID just adds to the confusion, really.
Tuesday, September 25, 2012 12:47 PM
uh.. please elaborate... what are the steps in sharepoint foundation to do this?
Mike
Tuesday, September 25, 2012 12:48 PM
In this answer you state that updating should work and that is not the case.
Mike
Tuesday, September 25, 2012 1:02 PM
Editing the *field* will update all items correctly, but editing the *item* will break the ID .
Friday, July 11, 2014 2:51 PM
Please could you explain me the process to create a wokflow in order to edit an Id updated?
Thanks a lot
Friday, July 11, 2014 2:54 PM
No it is not a good way because when several persons work simutaneously on the same sharepoint site, they can choose teh same Id
It is not good
Friday, July 11, 2014 2:55 PM
What is a propper formula
Friday, July 11, 2014 2:55 PM
Could you explain more please
Thanks
Friday, July 11, 2014 2:56 PM
It doesn't work