
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 11, 2021 07:10 PM
I am trying to make a simple sales table that will communicate with my inventory table to subtract what is sold and show me how much inventory I have left. I don’t understand most of the lingo…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 11, 2021 07:58 PM
Would you be able to post a screenshot of each table?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2021 05:09 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2021 07:42 AM
In your Inventory table, add a rollup field that aggregates the Sales table’s {Quantity}
field. For the aggregation formula use SUM(values)
Turn your {Amount in Stock}
field into a formula field that uses this formula {Quantity Purchased} - {Name of your rollup field}

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2021 10:37 AM
So here’s the roll up field I made…
Then when I put in the formula for quantity in the sales section it says there is an error…

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Aug 12, 2021 10:43 AM
omg never mind! I got it!!! THANK YOUUU
