+5Hi Community,
I have an issue with an automation - I have created this, so that when a new organisation is added, they automatically get added to my H&S Declaration table - however everytime I turn the automation on it creates a random selection of additional duplicate records in the trigger table (Organisation)?
Any pointers on what I am doing wrong?
Thanks
+2Ah every time you turn the automation on, or every time it runs? And do you have any other automations that do create Organisation records?
Another way to troubleshoot, if you inspect one of these unexpected duplicate rows (in the data layer) and check its revision history, where (or what/who) does it say created the record?
+35
It’s because you can’t trigger your automation based on “when a record is created”, because that will trigger as soon as a blank record is created… before you have started typing any data.
You can change your trigger to “when a form is submitted”, and then add all your new organizations through a form.
Or you can change your trigger to “when record matches conditions” and use a checkbox field (or single-select field) to manually trigger the automation.
Hope this helps!
If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld
+31Hm, that automation looks fine, you’re creating a new record in HS Declarations and linking it directly to the triggering newly created Organisation record, right?
If I were you I’d investigate all the other automations in the base to see what may have happened, and what
If that doesn’t help if you could DM me a link to your base I'd be happy to take a look at it for you too!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.