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 |
---|---|
24 | |
13 | |
4 | |
3 | |
3 |