Calculation between apps - accumulated
Imaging the following:
I have one app - Projects - where I enter the main info for all my projects. In addition, I want a field/a list with costs linked to each project. Theses costs will be added from another app - Resources - where rates/prices are entered.
As long as I pick a resource in the Projects app, I want the specific cost/price to show in the Projects app.
For instance, the list of resources is a list of people with their own defined rate per day. If I pick two of these guys for my project, for 3 days, I would like to have the calculated sum to show:
Person 1 - 100$ x 3 days = 300$
Person 2 - 125$ x 3 days=375$
Total 675$ in a calculated field or in a list of costs in the Project app.
I have tried to establish relations and calculations across these apps (or tables as I view them...) but can't get it to work.
Any guess where I might go wrong? Maybe I'm trying to achieve something that's not possible?
It might be that you need a different relationship field for each person to make sure the calculation field picks the correct price for each person. Let us know via "Contact support" in top right corner of the Help Centre if you like our help setting this up :) If you can include screenshots of your apps this would be helpful as well!
Sara - Podio
For the moment we've worked around the issue by putting every info in the Projects app. Unfortunately you need to manually fill the rate/day field, but at least we have all costs in one app. We are planning to put calculation between apps at work for future releases, following what Sarah suggested in her answer. I think that's the easier and most effective way to make this kind of calculations.
Please sign in to leave a comment.