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...
@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...
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 ...
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 ...
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...
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...
