Guys, please help. I am trying build a stock...

(My Report) #1

Guys, please help.

I am trying build a stock inventory. But every time scan for “out activity”, the item name is not change to proprietary name.(only list the first of stock name).

I put LOOKUP, but still the same,

Is there any mistake procedure ?

Can someone help me

(Jonas /) #2

so you dont want anything to be shown if [Barcode] is blank, right?

just wrap your LOOKUP with an if() statement.

if(isnotblank([Barcode])

LOOKUP(…),

“” )

(My Report) #3

@Jonas I need the name listed as proper of reader from barcode. If I scan barcode on row 01 should name appear name item of row 01…en so on

for barcode at row 02 name should name item of row 02

(My Report) #4

I would the result when I scan barcode are :

70563xxxx translated to “keyboard” at name of application 1234567xxxx should translated to “Desk phone”

In my case no matter I scan for many items on stock, the name only stated “keyboard”

(Jonas /) #5
  • remove blank cells from your sheet above your headers - try using select() instead of lookup():

select(inventoryList[Name],[_thisrow].[Barcode]=[Barcode])