Display virtual coumn data in sheet

[mahh1998]

Hello,

Can anyone help me with a solution on how to display data from a virtual column in my google sheets.

The virtual column uses this app formula:
SUM(
SELECT(
Purchases[Antal],
[Produktnavn] = [_THISROW].[Produktnavn]
)) -
SUM(
SELECT(
Sales[Antal],
[Produktnavn] = [_THISROW].[Produktnavn]
)) +
[Initial Stock]

Is there a way to display the same thing in my google sheet while still updating the column. I am using it to update quantity in a inventory management app. I want to sync up this column to send an email if the quantity is below a certain threshold.

[QREW_Cam · Accepted solution]

This might make it easier.

- Make Lagerbeholdning a Number Data Type
- Make the App formula of Lagerbeholdning to: [Current Stock]
Every time this column updates this value you will update, which is good, but we need it to update anytime a Pur chase or Sale for this product gets added/updated/deleted

To accommodate for this need:

Add a column to the purchases table. [update], Regenerate the table and make the data type number (Number)

Add action to: Called update purchases: Table: Purchases // Do this: data: set values of some columns in this row,
> select the 'update' column. the formula to the right put:    [update]+1

> prominence: Do not display

Add a Bot:

Configure Event > Custom event: Table: Purchases // Data change type: All changes

Add a step > create a custom step > click step > Run a data action: run action on set of rows // Referenced Table: Products // Referenced Rows: LIST([Produktnavn]) // Referenced Action: 'update'

Repeat for Sales