Hello again, cannot move over this problem


the situation:

invoice comes, somebody writes to temp invoice 1 row = 1 product, can be many from 1 invoice


then smbdy fills same way the temp shipping note


somebody scans EANs (this info is not in this example table) in warehouse when the goods come = we know what product and what qty is in reality

what i want from airtable:


compare all items on same shipping note (in temporary) with the coresponding invoice, with the reality


we know the invoice nr and the shipping note


that means nr of products and qty in this step


then i wish to compare prices from invoice with the one in product


if there is any problem give me info where it is so i can resolve it.

seems to be easy, but its not for me (at least this time) - can use automations, make new colums…(i am owner of the db).


Thanks for answer or kick in right way :winking_face: