i am new to Airtable and i would like to seek your help on setting of my automation
i have 2 tables:
Table A - Store up the items information with price, name, cost, supplier name, etc
Table B - Store up the supplier name, credit limited, item code, etc.
So i would like to set up an automation, when i added a new record in table A, then airtable can find the new record and get the supplier name.
then it goes to table B search for this supplier name, if the supplier name exist, then do nothing, but if there is no this supplier name, then i create a new row.
Sorry that i am not very good in automation and would like seek your help to teach me the setup , thanks!!