Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Computed Field To Assign a Sequence Number TO a Listing

  Asked By: Karen    Date: Jan 06    Category: Sharepoint    Views: 6937

Is it possible to have a list field that atuomatically increments? I
have a requirement to create a suspese tracking list that contains a
tracking number that needs to be formulated as ddmmyyyy[seq no.] so
that each day the sequence starts a 1; e.g. the items added today
would be assigned a tracking number of
04112006001,04112006002,04112006003, etc. Tomorrow would start over
with 04122006001,04122006002,04122006003, etc. I have created a field
named Today to start with so that once I get the computation correct I
can delete the Today field and the list will use the real[Today] in
the computation.



13 Answers Found

Answer #1    Answered By: Alyssa Butler     Answered On: Jan 06

I would check out heather solomon's blog. There's some good
walkthroughs there about lists.

Answer #2    Answered By: Katy Patton     Answered On: Jan 06

but I don't have any programming info that could
address this issue.

Answer #3    Answered By: Ana Payne     Answered On: Jan 06

We are trying to convince themn to just go sequential and not restart each
day in which case we can use =TEXT(Created,"mmdd")&"00"&ID

Answer #4    Answered By: Hema Hegde     Answered On: Jan 06

Forget using: =TEXT(Created,"mmdd")&"00"&ID

That appeared to work because the list  items already had an ID. It wont work
for new items  beause they don't have an ID until you SAve nad close the new
item. So we added  another field  to the list called 'Sequence Number' and
used that in the computation:
=TEXT(Created,"mmdd")&"00"&Sequence Number

Answer #5    Answered By: Damon Garner     Answered On: Jan 06

How will you increment the "Sequence Number". Are you going to manually
put in an incremental value each time a new record is added  to the

Answer #6    Answered By: Megan Martin     Answered On: Jan 06

Does anyone have found the solution for this issue?

Answer #7    Answered By: Donta Kirkland     Answered On: Jan 06


Answer #8    Answered By: Cade Velazquez     Answered On: Jan 06

Can you tell me how please???????????????

Answer #9    Answered By: Ariana Christensen     Answered On: Jan 06

The office who owns the list  will enter the next sequence  number when they add the new list item.

Answer #10    Answered By: Darrius Whitfield     Answered On: Jan 06

I have a custom list  template for this requirement  that has the following:

<Field Name="TrackingNumber" DisplayName="Tracking Number" Type="Computed" ReadOnly="TRUE">
<FieldRef Name="ID"/>
<FieldRef- Name="Created"/>
<Column Name="Created"/>
<Column Name="ID"/>

This works. If the lsit has twenty2 items  already and I add a new item to the list today, the Tracking Number is 4/25/2006 11:0423 What I need to do is only use the date part of 'Created' and not the time portion.

Any ideas?

Answer #11    Answered By: Adrienne Greene     Answered On: Jan 06

which will display 4/26/2006

Answer #12    Answered By: Joshuah Huber     Answered On: Jan 06

We have got <ColumnName="Created" Format="DateOnly" /> to work.

Answer #13    Answered By: Laura Walker     Answered On: Jan 06

Below is the corrected version from the schema that produces a 99% solution.
It is 99% because it doesn't restart with 1 each day.

<Field Name="TaskID" DisplayName="Task ID" Type="Computed"
<FieldRef Name="Created">
<FieldRef Name="ID">
<Column Name="Created" Format="DateOnly"
<Column Name="ID" StripWS="True"/>

Didn't find what you were looking for? Find more on Computed Field To Assign a Sequence Number TO a Listing Or get search suggestion and latest updates.