Hi, I have two different apps.
Product Catalogue that allows users to add/update products for specific projects
A project specific ordering app that pulls in the catalogue data
The same table is in both apps, in the project specific ordering app the table is read only but still continues to update if the table is chnaged in app 1.
However, I was doing testing in an undeployed app and the project specific app would only update if it was no longer read only?
Is it normal for this to work for deployed apps but not undeployed?
A table in an app that is explicitly read-only is subject to server-side caching to improve performance.
In effect, when AppSheet sees a table is read-only, it assumes the data in the table will not changeโat all, by any means. So AppSheet copies the data from the data source and keeps the copy. Requests from the app for that tableโs data get the copied data, not whatever is currently in the data source.
I donโt know how long the data is cached, but obviously itโs long enough to be a problem for you. I donโt believe thereโs any way to affect this caching behavior.
I donโt know if it would work, but you could try changing Are updates allowed? from Read-Only to the expression, "READ_ONLY"
. My guess is the caching behavior is triggered by the explicit Read-Only setting, but not by an expression result.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |