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?

Technical Help
, ,
1

:robot: 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) 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!

2

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?

3

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
4

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?

5

Hey,

I did a small video recording that demonstrates the automation: Untitled - Descript

6

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?

7

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

Yes, but it will take a bit longer to complete, so there might be a small delay in marking records as duplicates