References

[Oleg_Romanenko]

Hello! How can take a “price” value from a table1 and use it in an expression in a table2? How the expression in the appsheet would look like?

[LeventK]

Hello @Oleg_Romanenko, welcome to the AppSheet community. You can use a LOOKUP expression for that:

LOOKUP("LookupValue","Lookup_TableName","Lookup_ColumnName","Return_ColumnName")

You may also refer to this help page for further information:

help.appsheet.com

LOOKUP()

Get column value from row in table

[Aleksi]

Another way is if you are using related table structure between these two tables with the ref field, you can read the price with a deref expression like [RefColumnName].[Price]