Auto generated numbers in wss list
I have wss list which requires a autogenerated number starts with specific number . I came to know after some google work ,it could possible if we use ID column in the sharepoint. I created a custom column given the formula "ID+500" .It worked well with what i created the items so far. When i create a new item after the above mentioned changes ,Its not incrementing the total number.I mean newly creted item id is 10, then total should come in custom column as 510.But instead of that number i am getting 500 only for every newly created item. Whats the reason behind that and how can i achieve my desired result? rijuv technical specialist,sharepoint
July 18th, 2011 4:44am

AutoGenrated column related formula will work only in this manner, because whenever you add a new item, only when the item is added the 'ID' is assigned for the item. so when you add a new Item the ID is 0 and the result which you are getting is correct. It worked for all the items you have in the list so far since those items are already assigned with an 'ID' field value. You have to either write an event handler overriding the item added event to get the solution or do something to update the item ( again may require some custom coding) after adding the same in the list. See this thread to acheive the same using SPD workflow : http://social.msdn.microsoft.com/forums/en-US/sharepointdevelopment/thread/867bcacd-d378-411a-849a-fc040de9e5da/ Regards, Aj (http://www.aj-sharepoint.blogspot.com/) MCTS
Free Windows Admin Tool Kit Click here and download it now
July 18th, 2011 6:21am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics