Chào bạn, Mình muốn giúp nhưng chưa hiểu rõ bối cảnh. Có lẽ bạn gặp vấn đề ở chỗ sửa rồi nhưng trong chế độ xem chính thì không hiện đúng kết quả sửa, còn trong chi tiết thì đã hiện đúng. Bạn có thể quay video thao tác rồi gửi lên xem. nhìn vầy khó trả lời
Hi @preethamm thanks for the update on this feature. On this comment:
Can you shed any light on the likely timeline for full release of Quick Sync to paying customers, and will it include these vital aspects that I believe are requirements of the complete solution:
-
Support for security filters referencing other (even multiple other) tables
-
Forcing VCs to update immediately on the device receiving the broadcast also. This could (probably should for battery purposes) be limited to VCs that should be affected by the updated row that is broadcasted, including in other tables – but importantly should occur on a context(“view”) basis. I.e. VCs should be immediately updated upon the user navigating to a view that shows data from a row that has been updated by broadcast. Context(“view”) triggered VC re-calc would enable a seamless UX and correct data presentation to the user including VCs but would not require full (and all) table VC re-calcs which is unrealistic in the case of regular broadcast streams on busy apps. (Note that with this suggestion, there would still be some inherited requirements for VCs to re-calc on other tables, other than the table with the row being viewed. Those descendent requirements are known by the table row in question however so should be possible). One way I currently force VCs to update immediately without a full sync (eg a parent row calculating something based on children rows), is to have the update action on the child row to physically update a column on the parent row at the same time. This column I usually call [ForceUpdate], and I set it to NOW() which forces the VCs to recompute immediately. I mention this in case it assists the dev team in any manner as to solution ideation for this critical aspect (I believe) of the full Quick Sync Solution.
-
Support for broadcasting updates to other open apps (within the owner account) that use the same underlying database tables, with the same inclusions as above.
Thanks, and I am investing a lot into AppSheet with the hopes / belief that with these updates the platform will get to where it needs to be soon.
2 Likes
Video đây bạn nhé
If you have DEREF ([cola].[colb]) or SELECT/FILTER in your security filters, this is not supported yet. There is a warning being shown (yellow traingle) indicating this.
2 Likes
Sorry I missed this thread. Unfortunately table references from parent are not recomputed with this update. This is the same behavior with a new row being added (and with sync pending). We would like to fix this but unfortunately, we are not there yet.
In my case, if I add new row in child table, the update will be shown in all views: form view, details view and deck view and the total value (VC) column in parent table is also updated . The update is not shown only in the deck view when I edit any column in child table while I still see the update in details view and inline view for what I edited in child table
The Appsheet team has moved quickly on this new feature, and I very much appreciate it. I only recently added a more complex security filter to one of my apps, so I can no longer use Quick Sync. Can you give an idea of how long it might be until more complicated security filters can be used?
Thanks!
@Ryan_Wagner Thanks for trying out Quick sync and I am sorry that the feature does not work for you. What kind of security filter do you have ? (please feel free to DM me the details if it is easier). We are hitting the point where the tech limitations are getting in the way of what we want to do. Our next steps will likely involve more focussed set of upgrades for a set of usecases or data sources. So, any info would help prioritize work.
1 Like
Hi All - Thanks for the feedback! While we are still in Preview, we released this feature to everyone.
@preethamm Thank you very much for the reply. It was working great for me, but I had a specific need that required me to add another layer to my existing security filter, which disabled Quick Sync…
I will DM you my expression.
Is it possible to display which security filter stopping the Quick Sync to be turned on?
1 Like