As we all know, we still often have to rely on backend google scripts to do more complex operations like multi-row aggregations and such. This forces us to prompt our users for multiple refresh after a single entry. This is a pretty significant user experience killer, not to mention the high risk to data consistency. Are there any progresses made towards resolving this weakness?
I may be oversimplifying, but what is needed is a mechanism, or a column type, that says to appsheet that this row must complete a backend script operation, and that it needs to be refreshed once more transparently to the user (from the user perspective it is a single save operation). Obviously this would be super time costly, but never as costly as having to do multiple refreshes. And a much better workflow.
For example: Letโs say we have a new column type called โCallbackโ. This tells appsheet that it must cache the row data from a form save operation, and that it needs to re-read the row in n miliseconds, and if โCallbackโ value = โDoneโ (which would have been set by the backend script), it re-saves the whole row. There could also be a โnumber of retriesโ parameter on the Callback column, so if the Callback value is never set to โDoneโ (because the backend script is failing) the complete row update is canceled with an appropriate error message.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |