How to auto update a value into a form once another form updated

[Robin_Zeng]

Hi there, I’m still new to Appsheet.

Here I have two forms, form A is a check-in form and form B is a stock form.

There is a column called “Condition” that will record the device condition in both forms A and B.

Now, if anyone inputs a new record into form A, I want it will auto change the “Condition” in form B automatically. How can I achieve this? Do I need to use a bot?

BTW, There is another column “SN#” to locate each device. Basically, The “SN#” is the key in form B. But there will may several same “SN#” records in form A. I want to always use the latest “Condition” to update form B with the same “SN#”. Also, there will be forms C, D, E… and all may want to change the “Condition” in form B as well.

[Marc_Dillon]

https://community.appsheet.com/search?q=update%20other%20table

[Robin_Zeng]

Thanks, @Marc_Dillon. i tried using input(). I don’t quite understand this function yet, but now it changes the “conditions” of form B based on the input of form A.