Solved

Calculate field in sharepoint when creating a new item

Posted on 2004-09-09
4
282 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
home folder path for users 4 98
Event ID: 5719 / Source: NETLOGON 9 161
Drive mapping problem 7 41
AD account Auto logoff 1 35
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.…
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

713 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