# Can Baserow automatically detect duplicate Instagram usernames in a table and mark them as duplicates, and if so can someone help me set it up?
**URL:** https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551
**Category:** Technical Help
**Tags:** automation, help-wanted, formula
**Created:** [June 16, 2026, 9:19pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551 "2026-06-16T21:19:34Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Joe.eynon](https://community.baserow.io/u/Joe.eynon)
#### Post date: [June 16, 2026, 9:19pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/1 "2026-06-16T21:19:34Z")
### 🤖 Kuma (Baserow’s AI assistant): often the fastest way to get help. Try asking Kuma before posting here. Available to all SaaS users, and to self-hosted users with a connected AI model.
on
### Are you using our SaaS platform ([Baserow.io](http://Baserow.io)) or self-hosting Baserow?
SaaS
### What are the exact steps to reproduce this issue?
Hi,
I am building a lead database in Baserow and I’m trying to detect duplicate Instagram usernames.
I have a table called Main with a field called Instagram Username.
What I would like is:
- If a username appears only once, do nothing.
- If the same username appears more than once, show “Duplicate” in another field called IG Duplicate Status.
Example:
joe → blank
sam → blank
joe → Duplicate
Ideally all matching rows would show “Duplicate”, but I would also be happy if only the later duplicate rows were marked.
I have already tried Kuma, formula fields and workflows, but I haven’t been able to get this working.
Is what I’m trying to do possible natively in Baserow, and if so what would be the recommended setup?
Thanks!
---
### Author:  [@olgatrykush](https://community.baserow.io/u/olgatrykush)
#### Post date: [June 17, 2026, 12:37pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/2 "2026-06-17T12:37:31Z")
Hello @Joe.eynon, de-duplication as a built-in feature is not available yet, but we’re planning to start working on it very soon.
I remember you, @frederikdc, built a similar system using Automations, didn’t you?
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [June 17, 2026, 1:08pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/3 "2026-06-17T13:08:13Z")
You can indeed create an automation for this:
1. Trigger: when a new record is created
2. List Multiple records: get all the records with the same value for the instagram username but not the same row id as the newly created record
3. Loop over the found records and mark them as duplicate
---
### Author:  [@Joe.eynon](https://community.baserow.io/u/Joe.eynon)
#### Post date: [June 17, 2026, 10:07pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/4 "2026-06-17T22:07:37Z")
Hey Frederik thanks for this idea are you able to share some screenshots of how you did this or if you would be open to connecting on a call?
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [June 18, 2026, 8:02am UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/5 "2026-06-18T08:02:22Z")
Hey,
I did a small video recording that demonstrates the automation: [Untitled - Descript](https://share.descript.com/view/VBK2U6v1uzs)
---
### Author:  [@Joe.eynon](https://community.baserow.io/u/Joe.eynon)
#### Post date: [June 18, 2026, 8:02pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/6 "2026-06-18T20:02:33Z")
Is there a way to do this so lets say everytime I change the userame in the row or get rid of a username in the row it updates the duplicate status so if I get rid of the useraname in the username column that has a tick by it the tick disappears also if there is a tick by a username and I change it to a unique username that is not a duplicate one is there a way it can untick the box and visa versa for when there is a unique username that is not a duplicate and then I switch to one that is?
Also will this autoamtion work for me if I h ave like 600 usernames in there and I am adding more people?
---
### Author:  [@frederikdc](https://community.baserow.io/u/frederikdc)
#### Post date: [June 22, 2026, 12:56pm UTC](https://community.baserow.io/t/can-baserow-automatically-detect-duplicate-instagram-usernames-in-a-table-and-mark-them-as-duplicates-and-if-so-can-someone-help-me-set-it-up/12551/7 "2026-06-22T12:56:41Z")
> [@Joe.eynon](#):
>
> Is there a way to do this so lets say everytime I change the userame in the row or get rid of a username in the row it updates the duplicate status so if I get rid of the useraname in the username column that has a tick by it the tick disappears also if there is a tick by a username and I change it to a unique username that is not a duplicate one is there a way it can untick the box and visa versa for when there is a unique username that is not a duplicate and then I switch to one that is?
You can use the HTTP trigger node as the trigger of the automation and use that url as a webhook for your table. It will fire the trigger every time something is updated in your table. More information about webhooks can be found at [Baserow webhooks guide for automation](https://baserow.io/user-docs/webhooks)
> [@Joe.eynon](#):
>
> Also will this autoamtion work for me if I h ave like 600 usernames in there and I am adding more people?
Yes, but it will take a bit longer to complete, so there might be a small delay in marking records as duplicates