Filter items on fields from app-reference!

Answered

Follow

Riël Notermans

• July 05, 2013 11:08

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?

 

 

 

5

• 

  Sara Høeg Højlund-Rasmussen

  • July 05, 2013 12:02

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

  Cheers,
  
  Sara - Podio

   

  0

  Comment actions Permalink
• 

  Riël Notermans

  • July 05, 2013 12:04

  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...

  0

  Comment actions Permalink
• 

  Sara Høeg Højlund-Rasmussen

  • July 08, 2013 14:08

  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

  0

  Comment actions Permalink
• 

  Riël Notermans

  • July 08, 2013 14:19

  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...:)

   

  0

  Comment actions Permalink
• 

  Sara Høeg Højlund-Rasmussen

  • July 08, 2013 14:21

  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

  0

  Comment actions Permalink
• 

  Riël Notermans

  • July 08, 2013 14:27

  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. 

  0

  Comment actions Permalink
• 

  Sara Høeg Højlund-Rasmussen

  • July 08, 2013 14:36

  I see :) Then it is a feature request!

  No current plans on this though.

  //Sara

  0

  Comment actions Permalink
• 

  Marcelo Lacerda Garcia

  • January 30, 2014 19:00

  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.

  0

  Comment actions Permalink

Please sign in to leave a comment.