Hi everyone, hope things are going well? This is just a quick and simple question relating to recommended approaches for how to structure expressions in a ‘Valid If’ column. So for this example I’m using the ‘Valid If’ to match a column entry with a list in another table. I’ve found two ways to do it,
use a referenced column (in this case called ‘existing products’) with a contains expression, e.g CONTAINS([Existing Products], [Product])
I skip the referenced column and just use a Select expression instead, e.g CONTAINS(SELECT(Customers[Products], [Customer] = [_THISROW].[Customer]), [_THIS])
My question is, which method is more efficient for Appsheet to process? I don’t mind either approach personally, but I would rather use the best option if possible.
Thanks for reading!
D
Solved! Go to Solution.
User | Count |
---|---|
28 | |
14 | |
3 | |
3 | |
3 |