Expression "IN"

[Roy217]

I am creating a simple inventory management app.

I am trying to use the IN expression but without success. The objective is to check if the scanned barcode is in the list so if it is the app will reject the input.

Online the only information i find is >> IN({*},{List}): returns true if a value is in a list.

How do i use this expression?

[JuneCorpuz]

IN(
	[barcode_number_column],
	table[barcode_number_column]
)

[Roy217]

The column name is “barcode scanned”

I tried IN([barcode scanned], table(barcode scanned))
Got an error “Unable to find function ‘TABLE’”

I tried IN([barcode scanned], LIST([barcode scanned]))
Did not work as well

[JuneCorpuz]

Roy217:

IN([barcode scanned], table(barcode scanned))

Change the table to the table name where barcode scanned is.

[Roy217]

Thank you!! it worked.

[Steve]

help.appsheet.com

IN()

Is item in list?