[Appsheet] Update Number of items

[voottinun]

Hi all, I have two tables

Table 1(Snapshot): keep the name of items and the current number of items

Table 2 (Transaction): store all the transactions.

For example, I want to add 3 more quantity of Item A. I key in the form in Table 2. The number of the same items in Table 1 should be updated by 3. Can someone share with me how to work on this? It sounds simple but I can't do it T-T

[JhunePol]

Hi @voottinun 

Meaning your Table 1 stored the list of items and the Table 2 is to add a quantity only?

Take a screenshot of your app.

[voottinun]

Hi JhunePol,

Table 1 (Transaction Table) stores: Transaction Type (Add / Remove), Item name and quantity

Table 2 (Current Snapshot) stores: item name and current quantity

Anytime that there is a new transaction created on Table 1, the number of the quantity on Table 2 should also be updated.

For example, Table 2 has "Apple 100"

User creates "Add apple 20" on Table 1

Table 2 data should be "Apple 120"

[JhunePol]

Hi @voottinun 

Thank you for the details,

Hope this template helps you 🙂Try this one. Simple Inventory 

[Arni_Kli]

@voottinun ,

You can use one of next action in Table 2 by using a link to existing key of Table 1.
A) If the key exist then a row will not add but update using this key (check the other columns of this row, you may have to overwrite them with themselves).
B) You should filter desired row by this key and call an action from Table 1 (set the values of some columns):

A) 

B) 

Next step - you can make a bot with action or use a save button.