I have a a process automation that when a lead is converted to a customer (single select field), airtable automation create a new record in a client tab and a list of tasks to do accordingly.
I have 2 types of tasks, 1 for product 1 and 1 for product 2.
Everything works perflecty … however, when i selected 2 products for one customer I have a duplicate customer fields …
I checked with the delete duplicate script, but i want it to be automatic.
I attached screenshot, so maybe you can help … many thanks in advance ! Maybe there is some workaround with the automation set up. Is there anyway i can update when the client is existing, instead of creating a new line ?