Data from multiple tables into one view? Also, input/output log.

[pwncess]

Hi, I'm extremely new to this. Been trying to figure out the formulas and etc for awhile now.

I'm trying to create a stock inventory app. It consists of multiple tables (freezer stock, fridge stock, pantry stock). In each of these tables I have columns with item name, quantity & restock level (this tells at what quantity the item should be restocked). In the menu bar, I'm trying to create a view called  "Low In Stock" where when quantity < restock level, the item would appear there. I tried creating slices, but I'm not really sure about it, as its all individual slices as there's multiple tables. Is there a way to put the restock level data from all 3 tables into one?

Next issue is, is there a way to have a view where if quantity of item is added/deducted, it will appear a record with timestamp and also if possible a USER who made that change.

I've tried to follow the Simple Inventory template, but my tables are also kinda different so I can't really apply to that.

Any help is much appreciated, even better if it's accompanied with step by step screenshots of how to do it, as I'm just really new to all of this. Thanks!

If you need pics of what I'm talking about, let me know!

[1minManager · Accepted solution]

So having mutliple tables for data which is very simial is a bad idea for two reasons.  Firstly as you've discovered its hard working with multiple tables and sometimes it can be impossible to do what you want in an simple way.  Secondly during a sync Appsheet reads each table seperately, though it can read I think up to 3 in parallel.  The more tables you have the slower the sync might be.

 So, anwers to your points:

1. "Is there a way to put the restock level data from all 3 tables into one" - I suggset you merge these into one table at the spreadsheet level
2. "is there a way to have a view where if quantity of item is added/deducted" - You need 2 tables, one to record each stock item, and a second one to record the movement of stock.  Then in the first table you'll use a virutal column to calculate the actual stock level from the data in the second table

Hope this helps getting you started

Simon@1minManager.com

[pwncess]

@1minManager I did think I'll have to merge it but was hoping there could be a way around this current setup. Thanks for you help!