Update Log when input/output (using "quick edit columns" feature)

[pwncess]

Hi, I'm new, really need your help on this.

I'm creating an inventory list. In my ref view for 'INVENTORY LIST_DETAIL', I have added two columns which allows me to make quick edits from this view.

Quick Edit columns added

Is it possible to create an update log that updates the quantity when it's (+) or (-), and also when any remark is added? Something like the Simple Inventory template below:

Also in the 'Update Log', besides having Item/Quantity/Remarks, I want to add a "User" column. I'm not sure if this user thing would work where whoever's using the app would have to log in to it, so when they make any edits, their name/email would automatically show up?

I think its something to do with some inline view thing? Which I'm struggling to figure out how to get it done, with all the Ref values and all...

I hope ya'll understand what I'm trying to do. Thanks!

[Austin_QREW]

Hi @pwncess ,

Great question. We have an inventory app template that you can use here. Let me know if the feature you are looking for is in this app. If not, I can explain how the inventory log was built or answer any additional questions you may have.

Copy & Customize: Inventory App

Thanks,

Austin from AppSheet Training

[pwncess]

Thanks for replying @Austin_QREW .

On the USER part, I think I've got it. But the other areas, I'm just still not getting it to work. Do let me know if anything's not right with my columns or formulas based on the pictures below.

Inventory List Column

 Update Log Column

As I've mentioned, I would like the update to appear along with a timestamp when I (+) or (-) the quantity of an item or even when I add an item using the forms. Just basically any input/output. Right now, when I (+)/(-), it just syncs and nothing appears in the update log. I've tried adding formulas and referencing, but I'm not sure if I'm even getting the formulas right or is there more steps to it.

Thanks!

[Austin_QREW]

Hi @pwncess ,

I see what you are trying to accomplish now. You can go about this two ways you can set up an automation to update the Update Log Table based on the Inventory List table or you can simply set up your log view and target your Inventory List table as your log table view. 

For Automations follow this set up: 

Data Structure: 

1. Add an ID column to both tables - Set these as the Key - with UNIQUEID() as the Initial Value

2. Add an Inventory List ID to the Update Log table

Automation: 

3. A new Inventory List Record is Created

• Data Change
• All Changes
• Table Inventory List
• Create a new automation - Run a Data Action: add a new rows
• Add row to this table - Update Log
• Set these columns:
  • Last Update - NOW()
  • Item - [ITEM]
  • Quantity - [QUANTITY]
  • By User - USEREMAIL()

Description: 

With this automation setup every time an inventory record is updated, added, or deleted it will add a new record to the Update Log table.

UX View Option:

For this option you will simply need to target your Update Log View to the Inventory List View and set the Summary Column to Quantity. This will ensure that every time the inventory item is updated it will show the record from this table. See the images below for more information. 

Hope this helps. Let me know if you have any questions about these setups. 

Thanks,

Austin from AppSheet Training

[pwncess]

Hi @Austin_QREW ,

Thanks for your help! I've managed to set everything up based on your explanation and some other tweakings of my own.