Sep 29, 2020 09:59 AM
We have a field called Brands and we’d like to filter out several brands from showing going forward. Instead of adding each brand name as a filter itself in the View, we tried playing around on filtering out by creating a new formula field, and add more brands as we go into that field formula, to no avail.
Here’s the formula - https://gyazo.com/6065751e7ed3d0b7f8a1ea2b7e3f5940.
What’s being done wrong? Thanks for your help and time!
Sep 29, 2020 11:07 AM
Have you considered making a Table for [Brands]
, and turning that SingleLineText field into a LinkToAnotherRecord field pointing at the brands table? That way you could have a a Checkbox field in [Brands]
to mark if the brand should be included. Then you could replace your formula field with a Lookup field pointing to that Checkbox and use it for the filter.
Sep 29, 2020 11:24 AM
Can you post a screen capture showing your field setup and desired output?