Best Practice : Should use formula at Spreadsheet level or Appsheet level? and why?
Spreadsheet formulas will only be evaluated when the app syncs. If the app is used offline, the columns with spreadsheet formulas will not update at all until the app is online again.
Best practice is to use AppSheet expressions.
Ok thank you very much.
โฆand appsheet expressions less likely to slow down the app right?
In that they can update without a sync, yes. On the other hand, if you have complex/inefficient expressions for virtual columnsโthat only update in bulk during a syncโitโs possible spreadsheet formulas could be faster. Youโd have to test to find out. Still, best practice is to at least start with an AppSheet expression. Always keep in mind, though, that virtual columns will update automatically in forms, but spreadsheet formulas will not.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |