Automatically fill in values based on any column filled.

[Kaiz]

Hello Everyone,

I have a table called "Inventory", inside which contains columns [Product Category, Product Name, SKU, Barcode], all of these contain values for a single product where [Product Name] is the key.

Now i have another table called "Item QTY Data", inside which contains columns [Product Category, Product Name, SKU, Barcode, QTY]

I want to create a form for "Item QTY Data" where Appsheet automatically fills in [Product Category, Product Name, SKU, Barcode] if the user fills in any one of the four fields.

For example: If the user filled in [Product Name], [Product Category, SKU, Barcode] should be automatically filled based on the "Inventory" table. Or If the user filled in [Barcode], [Product Category, Product Name, SKU] should be automatically filled.

My problem is that if i used initial values for this, it would only work on the first try, as in after I change from wanting to fill in [Barcode] to wanting to fill in [SKU], the [Barcode] initial value formula wouldnt work anymore. I want this to be able to work no matter how many times the user wants to reset their choice, it should overwrite whatever value they have before in the textbox.

What I'm trying to achieve is similar to using App formula, but also allowing for user input if no other columns are filled.