Hello, everyone in the forum.
I am very new to AppSheet and struggling to update a table from another table with dynamic value.
I found this "Modifying data of a table from another table" page, and I managed to update a table from another table with a fixed value.
But I want to do it with dynamic values.
Here is what I want to achieve:
1. Select a row in the table view
2. Get a value from the selected row
3. Update another table with the value in the selected row
I tried [_THISROW].[columnName] and [_RowNumber], but I never had a luck.
The reason I want to do this is that I want to save the key value to fetch the selected row data in the form fields later.
My app structure is something like:
1. Select a row in the table1 and the view moves to table view of table2
2. Select a row in the table2 and the view switches to the table view of table 3
3. Select a row in the table3 and the table3_Detail shows up
4. Tap create form button to open a form
5. Open the form view
There is also a User data table, and I am trying to save the keys of the selected rows in there for cache.
When I open the form view, I would like to fetch the keys from the User data table and put values in the form fields when the form view shows up.
Is there any way that I can update the User data table with the dynamic values?
Or, if you have any other suggestions to achieve what I want, that would be fantastic.
Thanks in advance.
Check out INPUT()
Hello, Marc,
Thank you for your comment.
I checked the INPUT() in this page.
As far as I understand the article, it seems that you have to type in a value manually, but what I want to achieve is not like that.
I would like to update the User data table just by selecting a row.
Are there any ways to do this?
The bottom of that article links to this article:
User | Count |
---|---|
43 | |
30 | |
24 | |
23 | |
13 |