LinkedIn
Twitter
This needs fixed.
I have seen this in a production app-to-app interaction. The idea has been placed on hold until this issue is fixed.
I have reproduced the above production problem in a test app-to-app interactions and have previously submitted it in a bug request a couple months ago. I tested it this week and thought it was fixed.
Now, I am noticing it with simple manual changes to the sheet. (Images are below)
Basically, while testing, I am changing a value in the sheet manually. I sync and the value is reflected in the app table as indicated by the โView Tableโ function. However, the value does NOT reflect in the UI. It seems to me that if the app contains that value in the app-side table it should also be reflected in the views - immediately!!
This is where I think the bug is occurring - app-side updates - and it seems to be related to having the โDelta Syncโ function turned ON.
I think if I wait long enough, it eventually is updated in the appโs UI view. But definitely a refresh of the Editor page updated the app.
If I turn off โDelta Syncโ, changes are reflected as soon as I sync - each time.
Example images below
In row ID=2, updated Amount from 25 to 20
After Sync, Perform a โView Tableโ function, table data reflects change to 20
UI view still shows 25 as the value - even after several syncs and several minutes
After web page refresh, UI view then shows the correct updated value of 20
I have noticed the same behaviour. Also, whenever an action updates a row (Not a bot). It takes a while (Approx 20 secs) to reflect in the app if I donโt force sync. I have a security filter that will remove the rows with a simple condition like below.
Here the database in sheet is updated and set archive status to archived.
It still shows up here Until the sync is completed.
This kind of behaviour used to be there when I use Automation Bot when the changes are made on the server-side and it takes a while to show up on the app UI. But in this case, I use an action button just to change the Archive status.
This is what I was going to point out, but then I kept reading and saw you mention it. I believe your assumption is wrong here. In lots of cases it seems to be the same (like security filters), but Iโm betting that the โview dataโ button doesnโt care about the delta sync option, only the app itself does.
When youโre working with multiple apps (or multiple platforms) that are all using the same data source, delta sync causes lots of issues. Iโve seen it many times before as well. Just say no to delta sync.
I am going to disagree with you here. By turning on Delta Sync you basically told the system that a delay in seeing new data actually is acceptable. That it is acceptable in the name of faster sync times.
I donโt think you encountered a bug, and I donโt think Delta Sync is broken and needs fixed. I think it should just only be used in certain scenarios. And your scenario doesnโt sound like it is one of them.
Should the documentation on Delta Sync get fleshed out more, to include more warnings about using it in multi-app situations, among other things? Yah, probably. Oscar already linked this article in question, and quoted a portion of it, but let me post the entire section about Delta Sync:
Thatโs a pretty large โCautionโ section!
Device-side for sure, as it takes Security Filters into account. Or at least a close approximation of device-side. Keep in mind that what we see in the editor/emulator has always been slightly different than what is actually seen in the app. Iโm sticking with my guess that whatever request is sent when you click โview dataโ just doesnโt even consider the Delta Sync option. Because why would they build it like that? Youโre not concerned about sync speed when clicking โview dataโ.
All in all, Delta Sync is an option meant purely to improve sync speed, with plenty of cautionary messages about why you might not want to use it. And from the above doc, it appears that its method for determining when to sync is quite imperfect from the get go. Iโd highly doubt that it would even be feasible for them to improve on Delta Sync.
