?
Solved

Calculate field in sharepoint when creating a new item

Posted on 2004-09-09
4
Medium Priority
?
286 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1600 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

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

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

Organizations create, modify, and maintain huge amounts of data to help their businesses earn money and generally function.  Typically every network user within an organization has a bit of disk space to store in process items and personal files.   …
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

764 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