Calculate field in sharepoint when creating a new item

Hopefully this is the right TA for Sharepoint Questions....

I have a custom list setup that one column contains numeric values. What I want to do is when the user creates a new item for this list, take the value from the previous item, add 1, and pre-pop that field.

Can I accomplish this just in Sharepoint or am I looking at customizing with FP?

Cheers,
N

LVL 1
nickleplatedAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
kemp_aConnect With a Mentor Commented:
Unfortunately what you want to do is not possible. You cannot reference a value in a row other than the current row. You also cannot include column references in a formula that is specified as the default value of a column.

It's a pitty that the ID column is hidden, it would have been pretty handy for this!

Hope you can do what you want some other way.

Cheers
0
 
vxlilCommented:
hi nick,
please elaborate ur problem...

cheers
vx

0
 
nickleplatedAuthor Commented:
example of my existing list:

STN                  Client                               Month of Campaign
1234                 John Sample                     September
1233                 Joan Sample                     November


When the user creates a new record, they are presented with three fields:
STN: Number Field
Client: Drop Down
Month: Date Chooser

Using the example above, I want the STN field to automatically contain 1235. (Just like Autonumber in Access for example)

Make sense?
0
 
nickleplatedAuthor Commented:
Sorry, hadn't realised I hadn't closed this.
0
All Courses

From novice to tech pro — start learning today.