basenine 8/29/2019 12:48:00 PM
I’m not 100% certain if the following will help, but it’ll be worth a try.
Create a new Formula-Text field called [SEARCH PRODUCT]
Create Formula: List(“, “, [Product 1], [Product 2], ]Product 3], [Product 4])
In your view, filter with [SEARCH PRODUCT] Contains <Ask the user>
This should return all records where the product you’re searching for is in at least one of those fields
Let me know how you go 👍😀