Skip to main content

Hello, 
I am working with inventory management database. I have two different tables where both have unique UPCs and a status selection. I am creating a third table that will only display products from both tables that are ready for sale i.e status is “Listed”. 
I have created an automation that checks when status is changed to “listed” then find if that UPC doesn’t exist in product table then create a new field with that UPC. I run into duplicate entry problem. *** when I change a product to listed it will pop up in products list which is what I want but when I change the status to something else and then change it back to “listed” it will create a duplicate field which is not what I expect.***

  No matter who much I played around with different conditions and values in find section of automation I still couldn’t figure it out. 

Hi,
It should be done something like this: Find records in table, with this UPC, and then 
condition “If Length of Find Records list = 0” then create new record. 
After first time, in next run it will find a Record, so it will not create new

 

 


Hey ​@melad!

Would you mind further describing your database architecture and what is it that you are trying to achieve with the multiple tables?

I have the feeling that these could be achieved using Airtable Views rather than a third table and automations.

Feel free to schedule a call if you’d like us to go through it together!

Mike, Consultant @ Automatic Nation


Reply