I tried to copy a linked record cell down, but it returned a wong record.
I have a table of events, the name of the event (1st column of the table) will be reused every 3 years (same name on a different date). I have another table of event attendance. I tried to copy an event (a linked record) to other rows which are different attendees of the same event. The record returned in other rows are not the one I copied, it is another event with the same name, but it was 3 years ago.
I copied the event down, but it shows a wrong date. The date is a lookup of the event. Does copying linked record processed with the recordID or the first column? Is it a bug or I have done it wrong?
Thanks for your help!
Airtable will pick the “first” record (created) with the name you specified when you type, fill handle, or paste like that. I wouldn’t call it a bug, though it may not be desired behavior.
The way you get around this is by actually giving your records unique names. That is typically best practice anyway.
Eric, so good to hear that I am not the only one experiencing this bug-ish thing. Or at least changed behaviour.
I have also previously been able to copy/paste a specific linked cell, but now it pastes another record (though with the same value).
Also a small video from me for documentation: Loom | Free Screen & Video Recording Software
Will probably have to build a workaround at some point :smirk:
My workaround is to change my formula in creating the 1st column of the linked record table. Since my event name is a Catholic Mass title, it is strange to add anything extra to it. I have no choice, so just added the year at the end. I don’t understand why this copy and paste task cannot handle with the recordID instead of the 1st column value. In my concept, our table doesn’t need to have a unique key value because the recordID is unique.
JensChristian via Airtable Community Forum <email@example.com> 於 2022年7月5日週二 下午5:26寫道：