Good afternoon. Does anyone know how to apply what in excel is known as Index(Match())?
Solved! Go to Solution.
In Google Sheets it is also Index(Match( but if you're asking about AppSheet then I think you may not be understanding the way it work. AppSheet is primarily a database driven application and has a SQL-like expression language. So if you wanted to pull the value from the weight column for product ABC123 in a table of products, you would write something like this:
SELECT( Products[Weight], ([ProductCode] = "ABC123") )
It would probably be useful to refer to the following documentation
How to think about the design of your apps. |
In Google Sheets it is also Index(Match( but if you're asking about AppSheet then I think you may not be understanding the way it work. AppSheet is primarily a database driven application and has a SQL-like expression language. So if you wanted to pull the value from the weight column for product ABC123 in a table of products, you would write something like this:
SELECT( Products[Weight], ([ProductCode] = "ABC123") )
It would probably be useful to refer to the following documentation
How to think about the design of your apps. |
Te agradezco mucho Graham, la verdad es que yo no se codificar. Appsheet es una gran soluciรณn y ustedes acompaรฑan a las personas. Saludos!
User | Count |
---|---|
37 | |
25 | |
21 | |
20 | |
16 |