Help Please. I am trying to create what I thought would be an easy database on Knack. I have to track overtime hours that personnel work on the fire department. The formula is as simple as this:
Beginning balance + how many hours worked = balance
balance + how many hours worked = New balance
and this just keeps repeating.
The problem seems to be that you can't carry a balance from one record to the next. I am aware of the SUM function in Pages but that does not help my scenario. The SUM function does give me a balance, but it wont show everyones balance in one view. It will only show me the balance for one person, then you have to select another individual to see that persons balance. I would like the view to show all the personnel at the same time with their balance next to their name. Is there no way to accomplish this with Knack. Example:
Start Balance (numeric value) , Start Time (time)and End Time (time) Fields.
Create a numeric function to calculate how many hours worked
Create a numeric function called End Balance to calculate the total of start balance and total hours worked.
To show the total of the hours according to each employees, just add in the employees table a function to show the maximum number on the time sheet and that is the latest ending balance.