nusilmar
Member
Confusing to explain, hopefully not hard to understand.
I have the following :
A list where i create a support pack in hours for a client ( client A buys me a pack of 10 support hours) , this is in my contracts list ( id, date_time, customer ( databasejoin to my customer list) , date of contract, expiration date, type of package ( databasejoin to my package list), hours (cascading dropdown on package list), expires in ( calc field).
A list where i create service sheets made on a client ( Tech A goes to Client A and makes a tech job during 2 hours) , this is in my service sheet list ( id, date_time, tech ( dbjoin to tech list) , customer ( dbjoin to customer list) , hours spent.
What i intend to do is to have a running total to where i can track hours bought and hours spent , just like this ( but done automaticaly) :
Customer A , Contract XXX , 30 hours , Total 30
Customer A, Service XXX, 2 hours , Total 28
Customer A, Service XXY, 3 hours , Total 25
Customer A, Service XYY, 18 hours, Total 7
Customer A Contract XXY, 10 hours, Total 17
If this could be done, it would be wonderfull, on alternative it could be added a calc field on customers list with that value ( for witch i need help also)
Thanks in advance
I have the following :
A list where i create a support pack in hours for a client ( client A buys me a pack of 10 support hours) , this is in my contracts list ( id, date_time, customer ( databasejoin to my customer list) , date of contract, expiration date, type of package ( databasejoin to my package list), hours (cascading dropdown on package list), expires in ( calc field).
A list where i create service sheets made on a client ( Tech A goes to Client A and makes a tech job during 2 hours) , this is in my service sheet list ( id, date_time, tech ( dbjoin to tech list) , customer ( dbjoin to customer list) , hours spent.
What i intend to do is to have a running total to where i can track hours bought and hours spent , just like this ( but done automaticaly) :
Customer A , Contract XXX , 30 hours , Total 30
Customer A, Service XXX, 2 hours , Total 28
Customer A, Service XXY, 3 hours , Total 25
Customer A, Service XYY, 18 hours, Total 7
Customer A Contract XXY, 10 hours, Total 17
If this could be done, it would be wonderfull, on alternative it could be added a calc field on customers list with that value ( for witch i need help also)
Thanks in advance