How to perform action on virtual column???

[Forrest]

Im trying to perform one action to the virtual column in appsheet inventory management app. The virtual column in total available stock and I want to create a button that subtracts 1 from the total available stock column but there is no option to do so. The rows which are shown are in google sheets but the virtual columns are not present.

[mateo]

Virtual columns work on behalf of formula you write. They are "virtual" so you won't see them in your gsheet. It is impossible what you are trying to do. You can try to write formula connected to action on another column (I am just thinking 🤔). 

[Rafael_ANEIC-PY]

Hello, a virtual column is exactly that, virtual, as in it doesn't appear in your spreadsheet as the other "physical" columns, you can read more about that here:

https://help.appsheet.com/en/articles/919891-virtual-columns

As it doesn't exist physically, that has some limitations, but also many benefits.

Since it isn't actually stored anywhere, but instead it is recalculated on every sync, that means you can't just substract from it and then store the result, you need to register that substraction in your database in a way that can be accounted for in a expression in your virtual column.

For example, you could add a table for "Inventory movements" so that an user can log any reductions to a product's inventory.

I suggest you check out the inventory management templates to see some basic examples of how inventory is kept, here's a few of them:

https://www.appsheet.com/templates/Autocreated-from-Google-Sheets?appGuidString=de7161ae-4b66-49fc-a...

https://www.appsheet.com/templates/This-inventory-app-uses-barcode-scanner-to-record-stock-in-and-st...

https://www.appsheet.com/templates/An-app-for-streamlining-inventory-updates?appGuidString=225f95e5-...