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

Harold_Iliya
Participant II

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?

0 2 297
2 REPLIES 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
Participant II

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.

Top Labels in this Space