CHANGE THE COLUMN VALUE FROM ANOTHER TABLE WHERE A NEW ENTRY WAS ADDED

AppSheet AppSheet Q&A
1

Hi,

I was having a difficulty expressing an action where every new entry was added, I would like the column value from another table changed automatically for the latest value.

I have tried Data: set the values of some columns in this row and Data: add a new row to another table using values from this row but I do not know how to use it. Please kindly help, thank you.

3.png
3.png372×389 12.7 KB

log.png
log.png200×143 2.06 KB

main.png
main.png336×148 2.7 KB

2

Set up a “reference action” (action of type "execute an action on a set of rows).

Even better, use INPUT() with the reference action.

https://help.appsheet.com/en/articles/5398619-dynamic-inputs-for-data-change-actions