Change multiple cells at once...

[JohnYuen]

Hi Everyone, 

I have a warehouse to store products. 

I found that the same products from different suppliers come with different barcodes, like below image...

I created a Form view in Appsheet to update the Current Location of a product, but the same product comes with 5 barcodes... 

In my warehouse, what i usually do is to scan the actual product barcode, then the related product details come up and will have a "New Location" column for me to input. I simply, but stupidly, replace the Current Location with New Location 5 times...

is there any method to do the trick for me, to update the location to whatever barcodes with the same YuensCode? 

Thank you

[Marc_Dillon]

Check out 'reference actions' (actions of type 'execute an action on a set of rows'). Along with INPUT()

[JohnYuen]

Hi Marc, 

Thank you for quick reply, can you explain a bit more on this please?

[JohnYuen]

Hi Guys, above is my data example, i made something below to do the update: 

*Above is the Trigger

*Above is the button

it works partially that it updates only the row with the related barcode... 

I want to update the Current Location in Inventory with the New Location for all related YuensCode... 

still stucking..

[Marc_Dillon]

Use dynamic inputs for data change actions - AppSheet Help