With all of the amazing capabilities of AppSheet, it’s hard to find areas where there isn’t a work-around.
Like I always say… with AppSheet there’s
But sometimes, those work-arounds just won’t work in certain situations.
I have found myself in one of those situations. I COULD devise a system that would solve this, but this has brought to light a core functionality that we are missing with AppSheet.
We need the ability to PUSH data from one table to another.
With the current capabilities, we can slice & dice data in the following ways:
- We can create an action to set the value of a column
- this is a pull only system
- We can create a new record in a different table using values from the current table
- This is a way to push the data into a new table, but only with a new record.
But if we want to push data into a preexisting record - we can’t do that.
The best we can come up with currently, is to flag the item you’re wanting to push data from - isolate it out with a slice, then use a dedicated action to pull data from that special slice.
Again… pull only.
If we had a way to push data into a preexisting record - we wouldn’t need all that overhead. (Along with all the unnecessary back-and-form with the servers, which can cause problems if people are concurrently editing the same record trying to set a flag.)
I know this has been requested before, but I wanted to bring it to light again - as each time I encounter this problem, which is rare to be fare, I always come to the same conclusion: an action system would solve this problem.
This would round out the data manipulation methods you would ever need to do whatever with your data. Literally the last thing on the list here. (^_^)
As always, thanks for considering!