Hi,
I have 2 tables.
Table 1 (Scan In) - Date,User ID,Product ID
Table 2 (Scan Out) - Date,User ID,Product ID
Table 1 - Will not allow user to scan in more than 1 product until it is scanned out (This part is set).
I would like to remove the row in ‘scan in’ and copy the data to a different sheet if the ‘User ID’ + ‘Product ID’ matches in ‘Scan Out’ which will allow me to scan in the same User ID again.
Still learning Appsheet, new here.
User | Count |
---|---|
38 | |
32 | |
30 | |
17 | |
16 |