I am new to AppSheet, only two days into using it. I am currently exploring the Simple Inventory Template and am confused about the following:
I see two columns, InventoryID and Amount, which appear in the app but do not exist in the underlying Google Sheet data source (they are not Virtual Columns either).
Where are these two columns (InventoryID and Amount) being created or defined?
I noticed that when I input a value into Amount via the action LogInventoryChange (Inventory_Form), it seems to calculate and update the virtual column TotalStockAvailable (by adding or subtracting the Amount).
Where is the specific logic or expression for this addition/subtraction calculation defined?
Any guidance on the mechanics behind these two points would be greatly appreciated! Thank you.
These are definitely part of the datasource and included in the Inventory datasource. When you make an app copy - BOTH tables will be included in a single Google Sheets file but the file is named after the FIRST tab. See image below
Inside of the app defintion in the Editor there are table configurations and inside of that are column configurations. This is where you add Virtual Columns to the tables. They are columns that only exist in the app. It is within these Virtual Column configurations where you add the expression to perform the calculations. See Image.
Thank you so much for the incredibly helpful and detailed explanation!
I completely overlooked the fact that both tables were included in the same Google Sheets file (as separate tabs) but only named after the first one. That clarifies the mystery of the missing columns!
I also now fully understand that the calculation logic for TotalStockAvailable is defined within the Virtual Column configuration inside the App Editor.
I have a complete understanding now. Thank you very much—this was exactly what I needed!
