References

expressions
(Oleg Romanenko) #1

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?

(Levent Kulacoglu) #2

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:

1 Like
(Aleksi Alkio) #3

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]

2 Likes