When you input a not existed value in a linked column. A new record would be created in the linked table. How can I stop it from creating new records automatically?
Welcome to the community, Cheng! 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?
You can import to a different column, edit the usernames if needed then copy the whole column to the link column after processing.