I'm trying to update two column numbers based on a drop down selection and a number in another field, but only once a day. So if someone saves the record with the same inputs multiple times, the form/columns wont keep adding or subtracting the numbers over and over. If 16 are available and 8 already used, if you input 8 and save , available would be 8 and used 16. If you save again that day the number shouldn't change. (basically multiple entry error catching)
So.....
Dropdown Number
Item 1 [________________]
Item 2
If the user selects Item 1, the number would subtract from AvailableNow1 and add to Used1 in sharepoint list 1
Column Set 1 (used with item 1)
Available Now1 Used1
[_______________] [_________]
If the user selects Item 2, the number would subtract from AvailableNow2 and add to Used2 in sharepoint list 1
Column Set 2 (used with item 2)
Available Now2 Used2
[_______________] [_________]
but....
if the user makes a mistake with the item chosen in the dropdown and wants to switch from item1 to item2 after saving, is there a way to go back, essentially reset the daily total from columnset1 or columnset2?
