Ah 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?

​@WanakaShow 

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

Hm, 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 ​@jon21 said about looking at the revision history for those other created records would be where I’d start

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!