Thanks +Steve Coile!
The kind of sync I do a lot of in my app is where values already in the app are written to individual cells, often on another sheet.
When I use grouped actions to transfer several cells from the same row in one table to another row in another table (see following video) the syncs are done sequentially and take a fair amount of time (the time of the video has not been adjusted).
It seems to me that, on the whole, the combination of updating a single cell with an action and then having a couple more cells updated
via change columns is faster than three individual actions writing to different cells as you see in the video.
I wanted to have two modes for two different types of usage of my flashcard app for language learners: One would be for individual users who were only interested in their own progress and the other would be in for classroom situations.
In a classroom situation, more data would be collected for evaluation/grading purposes while such data collection would not be necessary for individual users.
I thought of having two “modes” for this reason.
My first thought was to have two versions of the app but then I thought it might be better if the user could merely switch to the faster “individual” mode for continued study after the course ended.
Even for individual users, however, a fair amount of data collection is necessary to make the app work properly and I’m beginning to think that the difference between the two modes may not be great enough to make presenting and explaining the choice worth the trouble.
Still, if change columns add significantly to sync times it would seem like it might be nice to be able to turn them on and off depending on the circumstances, as can be done with actions.
Moreover, more control would make it possible to only count certain kinds of changes as opposed to all changes in a column.
This can be done to some extent already but more power/options would be welcome.