How do You hide Inactive Product List in my Reference View

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

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”)

3 Likes