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?
Hi @ghadah_F
This is an action that you can attache to the Form behavior.
Please find an example here:
Please note the action of changing availability status will be performed AFTER saving
User | Count |
---|---|
42 | |
29 | |
28 | |
14 | |
14 |