So I have two list databases.
User Points User Submissions
These two databases work together. A user 'submits' for points in a status of 'submitted'/UserPoints[PendingPoints:Column] once 'approved' UserSubmission[TotalPoints:Column] points are now 'TotalPoints'
I have a work flow that does this math for me. If 'approved' CurrentUser[UserPoints]PendingPoints - CurrentItem[Points] then Add CurrentItem[Points]+TotalPoints then update list item. ^^^ This works but has this flaw...
If a user types a wrong point value it will double add... Or is the data is deleted it doesn't delete the item(s) points...
I am wanting to do a script I guess that would calculate a TOTAL colum defined by user.
Total database is 30 users.