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>>
)
Nice!
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
Yes CONTEXT("Host")="Server" works. It will not calculate for App users. But for the Bot.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |