AnsweredAssumed Answered

Filter Portal By Field

Question asked by mmichalak on Sep 25, 2018
Latest reply on Sep 26, 2018 by mmichalak



I am working on filtering a portal by a specific field. I have a table named "properties" and a field named "status". I am trying to have a portal that shows just properties where the Status=Under Contract. I created a relationship linked to the same table. Now I have a portal with a filter formula that = Properties 2::Status = "Under contract".


It works when I have one record selected with a status of "under contract" but when I have 2 or more, the portal just duplicates the first record. I end up with 2 of the same records in the portal.


I forgot to mention the status field is a drop down with different choices.


any help would be great. Thanks!