Hi, again!
We've got a request from the business to set up a yes/no property that looks for the presence of products (in a list of products on the contract) with the word "Software" in their name, and we've got several products that meet that criteria.
So, given these example products:
- Software Subscription - monthly
- Software Subscriptions - general
- Computer Software
- Hardware/Software
- etc.
Our current solution (which works!) is like this:
- Or(in(GetColumn([Product Table],[Product Name]),"Software Subscription - monthly"),
- in(GetColumn([Product Table],[Product Name]), "Software Subscriptions - general),
- in(GetColumn([Product Table],[Product Name]), "Computer Software"),
- etc. )
But, we were hoping to be able to use some kind of general/wildcard search, more like this (which doesn't work):
- contains(GetColumn([Product Table],[Product Name]),"Software")
So that if they create a new product, we don't have to remember to edit the formula and publish a new config, etc.
Anyone have previous luck with such a table-checking formula?
