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

[WillowMobileSys]

---

@trung0106 wrote:

However, the app is requiring the Item Name to be entered first, after which the Item Code is displayed

---

I am not exactly clear on what you are trying to accomplish or what the issue is.  Perhaps you are unaware of some built-in features?

In an AppSheet table, you have the ability to select one of the columns as the "Label" column - a column that helps identify the row to the user.  AppSheet will automatically use this "Label" column value as the display value anywhere in the app where the row is selected or to be selected.

For instance, if you set the Item Name column as the "Label" column, then in your transaction Form view, the Item Code field will show a list of of Item Names to choose from in the dropdown.  The Valid_If needs a proper expression.  See Drop-down on a Ref column 

Once an item is selected then you can have the field label show with the Item Code as shown in your second image.

I am aware that most warehouses know items by the codes and NOT the names.  So maybe you WANT the code to show in the Transaction Form dropdown and then configure the Form view to look like your second image???  If so then there will need to be some additional implementation to make that happen.

[trung0106]

---

@WillowMobileSys wrote:

For instance, if you set the Item Name column as the "Label" column, then in your transaction Form view, the Item Code field will show a list of of Item Names to choose from in the dropdown.  The Valid_If needs a proper expression.  See Drop-down on a Ref column 

---

thank for your support. Can you explain more for this? I mark Item Name as "label" then, when input the Item Code, it shows me the name of item as below.