Slice depending on another table

slice
#1

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

(Levent Kulacoglu) #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

#3

thanks a lot ! that worked well for me