Product management for ordering

[kira]

I have created an appsheet for internal orders where users can order goods in the app. I have 3 tables for this app mainly items, outlet references, and order details.in the items table, I have the column of 

Barcode

No.

Description

UOM

Manufacturer Code

Status

Stock

Aeon

Aeon Big

Jaya Grocer

while in outlet references I have the column of 

Customer

Outlet Name

Usoft Outlet

Customer code

Location code

and the table order details I have

ID

Timestamp

Staff Email

Order No

Barcode

Description

Type

No.

UOM

Qty

Outlet Name

Customer

Customer

Location code

Customer code

In the page order details in the appsheet, I want the customer to order the goods by barcode. However, if the item is unavailable, the user cannot order the items. I maintain the order by entering stock with Y or N in the column Y or N in the customer Aeon, Aeon Big. how can I do it?

[Aurelien]

Hi @kira 

You need to use a valid_if expression for the column that will scan. Basically, this is about using a FILTER() expression, with the yes/no condition to be matched.

For reference:

Drop-down from Valid_If - AppSheet Help

FILTER() - AppSheet Help

[kira]

i have use my valid if with Items[Barcode]