I have a problem with WSS v3 and calculated fields.
I am trying to create a custom list which provides a auto-numbered
column, based on the ID field.
I happily did this first with the UI, which at first glance worked
ok. I had a calculated field which was something like this:
CONCATENATE("PRJ",(1000+ID))
However if I add a couple of records, the cacluated field
(named 'Reference') would have the value "PRJ1000" each time. If I go
back in to the list settings and view the formula for the field
again, then click save, when I go back to the list item once more,
the field is populated properly, e.g. "PRJ1001, PRJ1002".
In understand that this is probably because when the list item is
saved for the first time, the ID column is NULL.
I moved on to creating the list as a custom list definition, as I
read somewhere that this may solve the problem.
But when I add the calculated field in the Schema.xml, I get a
SharePoint error. (I got the info from a blog
dev.collutions.com/.../DisplayPost.aspx?PostID=13,
which was for WSS v2 - I suppose I shouldn't be surprised to find it
failed.)
Can anyone assist me in making this work for V3?
I am an Admin rather than developer, so if the answer requires more
than 6 lines of XML, you may have to be quite specific.