Action based on 2 tables' data

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.

0 3 220
3 REPLIES 3
Top Labels in this Space