Slice depending on another table

Hello everyone, I was wondering if it was possible to crate a slice of a table which filer the rows depending on another table.
Thanks for helping if you can

Solved Solved
0 2 717
1 ACCEPTED SOLUTION

@JXNamor
Yes it’s possible with LOOKUP(…) expression but use of complex expressions in conditional settings are a bit expensive and therefore might cause sync duration to increase. I may advise creating a Virtual Column with an expression that will suit your needs to retrieve the evaluation criteria value from another table first and then use this VC’s value in the conditional rule. You can this page for further info:
https://help.appsheet.com/expressions/functions/lookup

View solution in original post

2 REPLIES 2

@JXNamor
Yes it’s possible with LOOKUP(…) expression but use of complex expressions in conditional settings are a bit expensive and therefore might cause sync duration to increase. I may advise creating a Virtual Column with an expression that will suit your needs to retrieve the evaluation criteria value from another table first and then use this VC’s value in the conditional rule. You can this page for further info:
https://help.appsheet.com/expressions/functions/lookup

thanks a lot ! that worked well for me

Top Labels in this Space