Applying a Price from another table

AppSheet AppSheet Q&A
1

Hi,

I’m looking for the expression to look up a price from another table that matches the product in the form that would be a REF in the same table.

Thanks,

Brendan

2

It’s hard to provide confident guidance without more information regarding your tables and columns, but here are a couple potential approaches.

[Product ID].[Price]

INDEX(SELECT(Products[Price], [Product ID] = [_THISROW].[Product ID]), 1)
2 Likes
3

Thanks for the quick response.

Table 1: Bottle Inventory_Powerhouse Ibiza (Source)

Table2: Bottle Sales

REF: Bottle ID to Bottle Type

Select goal : Price Per Unit (Bottle Inventory_Powerhouse Ibiza) – > Cost (Bottle Sales )

The goal is to carry the price that matches the bottle type from the database into the sales form.

4

I just tried it with your formula! it worked great thank you so much!

1 Like