Expression help!

AppSheet AppSheet Q&A
1

I have a

[Product] Table which contains;

•Product ID

[Size] Table which contains;

•Size ID

•Product column type Ref

[BOM] Table which contains;

•BOM ID

•Product column type Ref

•Size column type Ref

in my [BOM] Table’s Size column type Ref, I want to write an expression that says,

only show me the sizes that matches this Product ID. So in my drop down menu I won’t see every size of every product.

Tried to figure out myself and didn’t get anywhere close I think…

mine was,

IF(_THISROW =[Product ID], [Size].[Size ID], BLANK)

Can anyone help me out?

2

Hi @NCD

What about that in the Data Validity/Valid_If expression of your Size in the table BOM ?

[Product].[Related Sizes]
1 Like
3

Thank you, it worked!!

2 Likes