Solved: Auto update Inventory Master - Page 2

DME1 · 04-15-2025 02:53 AM

I have created an app sheet to track inventory for entries coming in and out. There are three sheets in Google Sheets: Inventory Master, In, and Out. When I enter In inventory, the Inventory Master should automatically update the "Received" column with the new entry. However, in my case, it does not update automatically. Instead, I need to edit the Inventory Master form and click "Submit" to receive the entry details.

Example:
In the Inventory Master, the stock entry shows as 0. When I enter a value of 100, I expect the Inventory Master to automatically update from 0 to 100. However, I currently have to go into the Inventory Master form, click 'Edit', and then 'Save' for the new entry to appear.

PauloExpert

Thanks for sharing the screenshots and context. You're on the right track, and this is a common AppSheet behavior—table values like “Received Stock” in the Raw Material table won’t update automatically unless you use App formulas or actions to recalculate them.

Here’s how to fix it so that your "Received Stock" column in Raw Material updates automatically when a new record is added to Raw Master In.

Goal:

When a new "In" record is added for a material (e.g., Apple), it updates the "Received Stock" in the Raw Material master table.

Step-by-step Fix

1. Make "Received Stock" a Virtual Column (or use an App Formula)

In your Raw Material table, go to the [Received Stock] column and set the formula:

SUM(

SELECT(

Raw Master In[Quantity],

[Raw Material] = [_THISROW].[Raw Material]

)

What this does:

It looks at the Raw Master In table

Filters for rows that match the current raw material

Sums the quantity values

> If you make this a Virtual Column, it will always stay updated. If you use a regular column with an App Formula, it updates only when the record is touched—but virtual is usually better for this kind of real-time summary.

2. Do the same for "Issues Stock" (optional)

In the Raw Material table, for the Issues Stock column, set:

SUM(

SELECT(

Raw Master Out[Quantity],

[Raw Material] = [_THISROW].[Raw Material]

)

3. Calculate Current Stock Automatically (optional)

Create a Virtual Column (or use an App Formula) for [Current Stock] in Raw Material:

[Received Stock] - [Issues Stock]

No More Manual Edits Needed

With this setup, your Inventory Master table (Raw Material) will update automatically whenever new "in" or "out" records are added—no manual edits or saving

View solution in original post