Post

2 followers Follow
5
Avatar

Filter items on fields from app-reference!

We are walking into a wall in the following use case:

We have companies, and companies have contacts. We have a 'contacts' app and a 'companies' app.

Companies can have a member status (gold, bronze, silver)

Now, I want to list all contacts of the companies with a certain member status.

 

 How can we do this?

 

 

 

Riël Notermans Answered

Please sign in to leave a comment.

8 comments

0
Avatar

I would filter from the other app? So, if you filter from the companies app you can find this?

Cheers,

Sara - Podio

 

Sara Høeg Højlund-Rasmussen 0 votes
0
Avatar

I can filter from the companies app. Then I see a list of  filtered companies, but I cannot see a list of the contacts that are referenced by them...

Riël Notermans 0 votes
0
Avatar

If you filter to see all companies having member status gold as example, you can save this view in table layout and hide fields so you only see the contact field in the list?

Let us know here if you need help.

/Sara - Podio

Sara Høeg Højlund-Rasmussen 0 votes
0
Avatar

Well yes but then I only have the 'app reference' title (like the first field of the referenced app).

I am afraid I am not expressing myself okay... lets go picture it:

CONTACTS:

first last age company (app reference)

jan janssen 35 a

piet pieters 25 a

henry boo 23 b

anton antons 40 b

peter peters 42 c

peter antons 24 a

COMPANIES

name status

a gold

b silver

c gold

I want to find ALL contacts and ages, where all companies are GOLD. 

It should return

jan janssen 35 a

piet pieters 25 a

peter peters 42 c

peter antons 24 a

Your suggestion would return:

jan

piet 

peter

peter

as being the first field of the referenced app.

I know podio is not a database...:)

 

Riël Notermans 0 votes
0
Avatar

What is the first field of your Contacts app? A text field - or a Contact field?

When I do this I get first name and last name because I have a contact field :)

//Sara - Podio

Sara Høeg Højlund-Rasmussen 0 votes
0
Avatar

We cannot use contact fields because it lacks "First name' "Middle name" and more (I think quite obvious contact items). Pity, but contacts is a separate app now which works fine. 

The feature would work in a lot of cases, i.e. list all projects where the referenced company is in a certain city etc. 

Riël Notermans 0 votes
0
Avatar

I see :) Then it is a feature request!

No current plans on this though.

//Sara

Sara Høeg Højlund-Rasmussen 0 votes
0
Avatar

I think this question is very important. I am evaluating the use Podio for an organization, but honestly, I do not know how to use it by not being able to filter reference applications.

Marcelo Lacerda Garcia 0 votes