Hi I need help please. Ill try give as much detail as possible.
So I have a business where I have the following apps/tables
1) Clients (phone, address etc)
2) Projects (status, budgets etc)
3) Invoices (Total, paid etc)
These are all linked to each other. My problem is that I want to build views in the invoices section that shows invoices by address/city etc. Ideally a map. However no matter what I try like lookups and even formulas to pull the address detail from the linked client page it does not accept it as an address. I was hoping to do similar at project level
Id rather not have to add addresses to each project/invoice when we have a lot of projects/invoices for same client.
Am I doing something wrong here?
Or is there a way I am missing?
Thanks
Robert