Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 28, 2022 03:26 AM
Good afternoon
I am currently doing a personal nutrition project and I want to solve the following question:
There is a table of products, and I want to check for a duplicate when a new record is entered, maybe such a product was already in the database
I tried to do it through automation, and mark a duplicate, but automation does not work
Maybe someone else knows how to deal with entering duplicates in one table?
Solved! Go to Solution.
Jul 28, 2022 04:37 AM
Hey Andrei, I tried to watch that video you linked but there wasn’t any sound, so I’m not really sure what’s going on.
One thing I would like to check though is how you’re creating the record. Your trigger is “When record created”, and if you’re creating records manually then that would run immediately, even when the Name
field is blank which may be causing these issues?
Jul 28, 2022 04:37 AM
Hey Andrei, I tried to watch that video you linked but there wasn’t any sound, so I’m not really sure what’s going on.
One thing I would like to check though is how you’re creating the record. Your trigger is “When record created”, and if you’re creating records manually then that would run immediately, even when the Name
field is blank which may be causing these issues?
Jul 28, 2022 04:43 AM
I shared on youtube
I think so, problem in trigger
I try to use FORM view and this aoutomations run normal
Jul 28, 2022 04:51 AM
Ahh, yeah, then that should be the issue. You could look into using a checkbox to trigger the automation instead perhaps?
Jul 28, 2022 04:56 AM
I would to instance control dublicates
Thx for the idea, i make trigger “then field update” for name and now this works good!