Using Slices only for Bots (increase sync time?)

[Fabian_Weller]

We have some Bots that do data change / delete actions every night. Since the expressions are complex, we use a Slice to prefilter the rows. The Bot works on that slice.

As I learned from @Steve here and here, a slice can increase sync time and performance.

I can not see this reflected in the Performance Profile. Or is the calculation time for a slice just added to the "Read a single table" or the {"SchemaName":"TableName_Schema"} ?

One way to tell AppSheet to calculate the slice only for the bot (not for the users):
Wrap the slice expression into a CONTEXT() expression. Like:

IFS(
  CONTEXT("Host")="Server",
  <<Your_Expression>>
)

[Joseph_Seddik]

Nice!

[1minManager]

Weirdly this would have helped me yesterday.  I needed an expresion to let a Bot edit a row, but not anyone else.  I tried ISBLANK(UserEmail()) which didn't work and settled on UserEmail()="" which did.  But CONTEXT("Host")="Server" if it works seems more precise.

Simon@1minManager.com

[Fabian_Weller]

Yes CONTEXT("Host")="Server" works. It will not calculate for App users. But for the Bot.