Update table 1 (specific cell) with info entered into table 2

[RCooper]

Hi,

I am looking to update a table with information entered into a second table - new to this, thanks for your help!

I have a spreadsheet with 2 tables, one which acts as a stock list of single items and another as a place which allows you to look up an item and record a 'job code' when a barcode is scanned.

Table 1

Table 2

Everytime a barcode is looked up and a new job code entered on table 2, I would like this to replace the corresponding job code cell on table 1. 

I have followed the tutorial to create an inventory management app and referenced my tables using the barcode column but I am struggling to create an Action which will allow the above.

https://blog.google/products/google-cloud/how-to-build-an-inventory-management-apps-no-coding-necess...

Thanks again for your help,

Roger

[1minManager]

So you're gonna need to create to actions.  The first is a set the value of some columns in this row type and will be on Table 1.  This will do the "replace the corresponding job code cell on table 1" work.  The second will need to be a execute an action on a set of rows type action where

https://support.google.com/appsheet/answer/10107706?hl=en#zippy=%2Cdata-execute-an-action-on-a-set-o...

Referenced Table = Table 2

Referenced Rows = A formula to pick the exact row in Table 1 you want to update.  But note that the result will need to be the Table 1 key column and you can't just use an ANY(Select(... formula.  Since Appsheet is expecting "...a set of rows".  So you will need to use LIST(ANY(Select(... to sort of trick it into thinking its going to be multiple rows

Referenced Action = This will be the action you created above

Hope this helps 🙂

Simon

1minManager.com

[RCooper]

Thanks for your help Simon

I have been able to set up the first action which now takes me to a separate page within the app and gives me the option to copy the job code over but I'm struggling to see how to make this automated using bots.

For the second action I'm not sure how to find the required code to pick the correct row from the first table and even to reference the first action.

Would you be able to recommend a tutorial to follow in order to learn this process?

The tutorial for learning the essentials of actions doesn't seem to cover this:

https://www.youtube.com/watch?v=WVyIfgVedx8&t=425s&ab_channel=AppSheet

And the closest app template I can find doesn't use this kind of functionality:

https://blog.google/products/google-cloud/how-to-build-an-inventory-management-apps-no-coding-necess...

Thanks again,

Roger