hi, I have a stock app. If I scan an item, ...

(Harold Iliya) #1

hi,

I have a stock app.

If I scan an item, which the number and quantity is already there, it gives me a new row. What I actually want is, if it sees that the item number exist on the stock column, than only to modify the quantity cell How do I achieve this?

(Aleksi Alkio) #2

Do you mean if that item exists on your table, show the quantity field? If that’s the case, you can type into the Show_If like…

IN([_THIS],TableName[Item]).

(Harold Iliya) #3

what I mean, I have two columns, one is the part number, the other is the quantity, for example: part number = 12345678, quantity = 2 when I scan with the barcode, I put 2 in quantity and “save” than, if it is a new part number = new row. existing part number, the quantity is 2+2 (on the new input) = 4.