Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 289
  • Last Modified:

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?


  • 2
1 Solution
hi nick,
please elaborate ur problem...


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?
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.

nickleplatedAuthor Commented:
Sorry, hadn't realised I hadn't closed this.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now