AppSheet Function

[Anzhelika]

Hi guys!

I can't figure out how to set up a selection of products by 2 criteria. In one table, I have products and their characteristics, one of which is type. In another table, I have form and the type of product. In the third table, I have the compatibility of the product and the form. I just want to write a formula that will help me filter products both by compatibility with the form and by the type that is indicated on this form. I've written a formula so far that filters compatibility using a SELECT formula.

Is it possible to customize a selection of products by 2 criteria?

Help me please

[Anzhelika]

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/function-for-AppSheet/td-p/616212

I was helped to set up the selection in this post

[Anzhelika · Accepted solution]

I've understood. auxiliary virtual columns