-1

I have a list where user can request amount of 1000 either one time or two time, if user request a amount, sharepoint automatically check with previous amount and subtract from 1000. suppose: A request 500 one time, next time if i create a list it will check the previous amount and let me know that i can only request 500 max.

Riz
  • 1
  • 2

1 Answers1

0

Unfortunately, calculated column formulas can only access values from columns on the same list item.

To query the list and retrieve values from other columns, here are a few different options you could consider, depending on your comfort level with the various technologies:

  1. Custom Workflow (created using SharePoint Designer or a third-party product like Nintex Workflow or K2).
  2. A custom list event handler (created using Visual Studio)
  3. A custom form (using InfoPath or a third-party product like Nintex Forms)
  4. Custom JavaScript on the New Item form that would override the PreSaveAction() method, query the list (using the SharePoint JavaScript Client Side Object Model, SPServices, or REST web services), and return True or False depending on whether you want to allow the item to be created or not
Thriggle
  • 7,009
  • 2
  • 26
  • 37
  • i said that i need to get the information from same list , not different list, so how can i perform this , i have nintex , if you can let me know which option should i use – Riz Oct 14 '15 at 12:44
  • Sorry, you missed a word in my answer: Calculated columns can only access values from columns on the same list **item**. I'll update my answer with a suggestion for using Nintex Workflow – Thriggle Oct 14 '15 at 14:12