Is there a simple way to change the value of the column of an existing row in table2 using the value from a column of the selected row in table1. There is a feature "add a new row to another table using values of this row, but I don’t want to add a row to table 2, I want to change the value of a column in an existing row of table 2, based on the value of a column of the selected row in table 1.
No Simple way. But you can vote, here:
I just voted for this feature. It would be a great improvement. Thanks!
In the Feature Request you just voted on, you might want to read the second post in that thread. It refers to the capability of using the AppSheet API to accomplish the update you are requesting. It is relatively easy to utilize once you understand it. I actually have not tested this out myself since I had already built other mechanisms to do it. The API method would be much simpler.
This loink will take you directly to that post: