How do You hide Inactive Product List in my Reference View

[JJH_Coetzee]

Hi I am quite new to Appsheet

I have Created a Product List and Have added a Status Field (Called Active And Inactive)

When i create my Record form that have a reference List Back to The Product List i would like to have only the active Products listed in my reference Dropdown

Is this Posible

[taufiq_qurohman]

Of course you can, this method works well
You only need to put this expression in the data vilidity valid_if which is located before the formula/initial values,…

FILTER(“Table”,[Product Status]=“active”)