There are few posts and threads, questioning how to “Update rows in other table using the value in this table and row”. recently I read.
As far as I know and if I did not miss useful tips and thread in the community, my understanding is only Appsheet API is assisting this particular jobs.
On my exiting and running App, I m juggling two different ways, one is use of API and other is Action only, to update the other rows using the currently working table/row value. So please let me introduce the one which will not require API set up, but just do a job with Action only.
The trick is a bit complicated, difficult to explain. Therefore, I prepared sample app for those who are looking for a solution.
https://www.appsheet.com/samples/Sample-App?appGuidString=f09ceb4d-309c-4213-a58c-f97245c2698d
This involves various action (but dont worry, just 4 actions only) as well as workflow and slice. For those who just started with Appsheet may find difficult to understand, but I would suggest that you copy this sample app and dig the details to learn how the actions are prepared.
I also placed a brief explanation about the process to generate this sample app, that I hope is going to be found useful while we wait for new feature to manage this job.
In the meantime, I hope Appsheet dev team will make this far easier to do the same jobs with easy set up through the native and single action with their new feature.