Update a row on other table

AppSheet AppSheet Q&A
,
1

My application serves the inventory of devices such as computers, printers, etc. in the company, There is a table that contains the items and their models, and another table that contains the serial numbers of the brand and model.

When the employee wants to exchange a specific device, he must choose the item and model, then a list will appear with the serial number of the devices available for that particular model.
The serial numbers of items was categorized by a " yes/no " column called “available” to identify if this item with this serial number is free or not.

what I want to do is when the user submit the inventory log form the value of column “available” change from “yes” to “no”. Is that possible?

2

Hi @ghadah_F

This is an action that you can attache to the Form behavior.
Please find an example here:

[Finding sample app for Copy wholly row to another table for log](https://community.appsheet.com/t/finding-sample-app-for-copy-wholly-row-to-another-table-for-log/58453/2) Questions

Hi @eusy1327 Your request is not clear to me, but basically this happens here: Behavior/Actions/New Action ==> create the one you need [image] And in the form settings, you pick the “copying action” you need in the Behavior section [image]

Please note the action of changing availability status will be performed AFTER saving

3 Likes