Auto Compute the item name when user input item code

[trung0106]

Hi everyone,

I run a small warehouse, and I want to use AppSheet as an inventory management tool. Currently, I'm using Google Forms, but the form has significant limitations for the workers. My idea is that when workers enter the item code in column A, column B will automatically display the item name. I've set up the Item Code column as a Ref, and the Item Name column with the Initial value = [item code].[item name]. However, the app is requiring the Item Name to be entered first, after which the Item Code is displayed. This makes it even more difficult for the workers because the Item Name is quite long.

Thank you for your help