Radhe-iad - profile

Radhe-iad · Dec 06, 2022

Hi,I have a table where people insert new records through an Interface, one of these columns needs to be unique.My issue is that i cannot stop people from inputting the same data by mistake through Airtable's Interfaces (so for example they need to f...

Radhe-iad · Jun 08, 2023

@lukas_mayd your solution makes very much sense!I remember trying something similar but not being able to use it because it found the record we just created, but setting the limit at > 1 completely solves the issue and I feel very stupid for not comi...

Radhe-iad · Dec 15, 2022

That is indeed a solution, but one I cannot apply because the ID they have to input is a number given from another private system (that cannot comunicate with Airtable, sadly), so the ID has to be an arbitrary number.It's like having to input a name ...

Radhe-iad · Dec 13, 2022

The user CAN check if the number already exists but i don't want to count on it because it's poor design and a hassle.So here is an image i made to try and explain the workflow and the problem, on the left you can see the column with the IDs, on the ...

Radhe-iad · Dec 09, 2022

I think i found a workaround through automations and a new table:I created a Check duplicates table (Table B) where the only thing i do is linking every single record from the table i want to check (Table A).I trigger the automation everytime a new r...

Radhe-iad · Dec 09, 2022

Sadly that's not a solution, when a duplicate is found we need to send an email warning to tell us that who put the data did it in the wrong way and we need to manually act on the database to correct a mistake.This solution is a workaround to not bei...

User Statistics

User Activity

Searching for duplicates and performing an automation when duplicate is found

Re: Searching for duplicates and performing an automation when duplicate is found

Re: Searching for duplicates and performing an automation when duplicate is found

Re: Searching for duplicates and performing an automation when duplicate is found

Re: Searching for duplicates and performing an automation when duplicate is found

Re: Searching for duplicates and performing an automation when duplicate is found