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.
Thanks Kamille for your reply! Well, I have done this task a lot of time in the same table before and the result is corrent. I do have different records using the same name before. The fact is the behavior of how Airtable handle this task has changed, or this is not the expected behaviour.
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.