The end goal is to run a report to show all the people that are listed as "owner" at a company, so that I can then send an email to all the company owners.
We have a "Companies" app and a "People" app. On the companies, there is a relationship field titled "Owner" that pulls in from the "people" app. All pretty simple so far!
As far as I'm aware (having spoken to Podio tec support) it is not possible to run the report mentioned above. But if I can reproduce the owners name (displayed in the relationship field) in a calculation field (so that just below the relationship field with the owner it shows the owners name again) on the company item, then I will be able to create the needed report.
This seems a little convoluted but would solve the problem. I just can't work out how to show that name??? It seems very simple to reference a non-relationship field in a calculation field, surley this could be done for a relationship field?