Solved

Calculate field in sharepoint when creating a new item

Posted on 2004-09-09
4
281 Views
Last Modified: 2012-08-13
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

0
Comment
Question by:nickleplated
  • 2
4 Comments
 
LVL 2

Expert Comment

by:vxlil
ID: 12025627
hi nick,
please elaborate ur problem...

cheers
vx

0
 
LVL 1

Author Comment

by:nickleplated
ID: 12026290
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
 
LVL 5

Accepted Solution

by:
kemp_a earned 400 total points
ID: 12355186
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
 
LVL 1

Author Comment

by:nickleplated
ID: 12841244
Sorry, hadn't realised I hadn't closed this.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Batuhan Cetin Within the dynamic life of an IT administrator, we hold many information in our minds like user names, passwords, IDs, phone numbers, incomes, service tags, bills and the order from our wives to buy milk when coming back to home.…
Learn about cloud computing and its benefits for small business owners.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question