Show product name when scanning Bar Code

[Michelle_Digi]

Hello,

I have a Products table with: Product name, Barcode (Key), supplier, etc.
Then I have a Sales table: with Product Name, Barcode, Date, etc.

In the SALES table I placed Barcode as Ref and Product Name as Text.
What can I do for the Product Name to be automatically Identified based on the Barcode.
I currently have the Product Name as text, with no formula or initial value. But it leaves the cell blank instead of generating the name of the product.

Thank you

[Marc_Dillon · Accepted solution]

help.appsheet.com

Dereference Expressions

Use a dereference expression to get a column value from the referenced row.

help.appsheet.com

App Formulas and Initial Values

How you can set app formulas and initial values to dynamically assign values.

[Michelle_Digi]

Very useful, thank you!