Linked Recrods via copy-paste Inconsistent results

[Paul_Warren]

I have been getting inconsistent results when inputting data in a linked record field. When I paste a comma separated list into the field, I randomly get one of the following results:

1. Linking to each comma separated record
2. Creation of a single new linked record with a long name of the entire list.

I have performed the paste action several times in a row and gotten different results. Can anyone explain why? Has anyone else had this?

Scenario 1 is the result I am expecting.

Thank you!!

[Nathalie_Collin]

Hi @Paul_Warren,

You should be getting Scenario 1 in that when you paste it, it will create a new linked record only if there isn’t one already there and if that record already exists, it will link to it. This is true even if the table is filtered.

The only way that I was able to replicate Scenario 2 was by using another symbol such as the other commonly used semicolon. Can you provide a sample text that is causing you to get Scenario 2?

[Paul_Warren]

I get this same result using the following two lists:

List1: 3.23, 3.24, 3.25, 3.26, 3.27, 3.28, 3.29, 3.30, 3.31, 3.32
List2: 10462, 10465, 10466, 10467, 10468, 10471

Also, both of these lists are from copying a similar linked record field (linking to the same records in the same table) on a view-only link. However, copying from the collaborator view doesn’t seem to change the result.

I believe I have fixed the issue by making the First column of the Linked table a formula. Now it seems less likely to think I want to create a new record with a text input. Still, it seems strange to get such inconsistency in the first place.

[Nathalie_Collin]

Aww, I wonder if it has something to do with a hidden html element? I’m not an expert in this area.
Sorry that I couldn’t be of more help.

[Paul_Warren]

Thanks for your input! That is very possible.