Welcome to the community, Cheng! :grinning_face_with_big_eyes: This feature can’t currently be disabled. It’s always going to create a new record in the linked table if the item you enter doesn’t already exist.
Can you describe more about your use case where you wouldn’t want that behavior to happen? Maybe there’s another way to structure your base to achieve what you want.
Thanks for your response Justin.
I need to copy user names from a Google drive spreadsheet. And some names may be slightly different from the one in the linked table. I would prefer airtable leaving wrong names as blank rather than creating a new record in the linked table. Is there any solution?
incredibly annoying! Please make this a feature, I’m editing a table for 1 hour now and I don’t actually know how many accidently created rows I had to delete in that time. PLEASE consider this feature request, @Justin_Barrett - or if that changed (I couldn’t find anything) please tell me how to do this. that would be a very simple checkbox which would smoothen my editing experience greatly.
Welcome to the community, @Axel_Bock! :grinning_face_with_big_eyes: I’m just a fellow user like yourself. My badge & label just indicate that I talk a lot, and sometimes it’s helpful. :winking_face: While there is a feature requests category that Airtable staffers peruse on occasion, the most reliable way to get your request in front of Airtable devs is to contact Airtable support directly.
Check extra spaces in field value.
If not, try to copy-paste both values into some record text fields and compare by formula (create new temporary table for that, if needed) . Sometimes it display value in a strange way, where & char present in text, containing line breaks.
Anyway, it’s a very useful feature, which can be used for grouping, find and mark duplicates, bulk dedupe or compare two arrays of values.
Another way to stop creating new records, besides calculated primary field, usable for temporary use before copy-pasting into link field - to set table permissions ‘Who can create records’ to ‘nobody’