I Have a form called "Client Projects" where I put a budget for the "Budget Hours", the "Budget Links" and a "Budget Network" for each project (so there's 3 different budget per client project).
I have another form called "Client expenses" where I put my expenses. These expenses go against the total link budget. The exact field is "Cost (CAN)". I have another form called "Client Project Hour" where I put my my working hours. These hours goes against the "Budget Hours". I have 2 fields for this, the first is "Hours", which is the amount of hours, and the second is "Rate per hour", because my rates are sometimes different. So when I put hours, I need to calculate the amount of hours times the rate to have a total. This total goes against the "Budget Hours".
Then I have a form called blog network articles. There will be a bunch of data in there and ultimately, they will have a status of "OK". Once they are "OK", I need a cost of 80$ to be put against the "Budget Network". So if I have 5 "OK" articles, I need 400$ to be put against the "Budget Network". Then, I need a way to be able to access all that data. Mainly, I need a screenshot of the total budget, the total expenses in each 3 different budget and the remaining budget in each ones. I need to be able to access it on a per project basis. Is this feasible and if so, can you create what I need?
For now my app is public at: https://creator.zoho.com/julienraby/julien-raby-client-tracker/
Thanks!
Julien
Writer is a powerful online word processor, designed for collaborative work.