How to retrieve a value

[Gaston_Montiel]

Hi, i have an excel that is updated using AppSheet. We scan a product’s SKU and it creates a new registry, this also trigger some formulas and update the excel with the product information, location in the warehouse, etc.

Now i need the app to show me the location in the warehouse of every product i scan, is this possible, if so, please help me out cause i can not figure it out.

[Aurelien]

Hi @Gaston_Montiel

You may want to use dereference expressions.
Such as:
[product_ID].[location]

please see also:

help.appsheet.com

Dereference Expressions

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

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

Core concepts & functions Expressions: The Essentials FILTER() List Expressions and Aggregates LOOKUP() MAXROW() MINROW() REF_ROWS() SELECT() What is a Key? Adding & updating rows Is this a new row?/Does this row already exist? What is the previous value of this column? Excel alternatives How do I do COUNTIF() or COUNTIFS()? How do I do SUMIF() or SUMIFS()? How do I do VLOOKUP()? Last row of the spreadsheet How do I get the last row of the spreadsheet? How do I get a column value from…